List all Registrations – The Shortcode [qemreport]

[qemreport] produces a report of all Events that have Attendees.

This shortcode is available as a paid for option.

There are several shortcode options that allow you to control what is displayed

Category Names

Option category_names='names separated by commas' will only display the events in the listed categories, note this uses 'names' as a search string, not slugs title e.g.[qemreport category_names='Free Events,Paid Events']

Events by ID

Option event='csv of ids' will list attendees of the events is specified e.g. [qemreport event='234,878']

Hide Payment info Columns

Option no_payment_info=true setting this will hide the payment information columns ( these can not be selected as 'fields' as they are not registration form fields.

Limit the maximum events to display

Option limit='number' will limit the maximum events to display e.g. [qemreport limit='3']

Limit to a specific year

Option yearnumber='YYYY' will just report a specific year e.g. [qemreport yearnumber='2021']

Select columns to display

Option fields='list of fields' will set the columns and their order to display e.g. ][qemreport fields='field4,field1,field2'] fields also need to be on the registration form to be displayed.

field1 - Name
field2 - Email
field3 - Attending ( or not )
field4 - Telephone
field5 - Places
field6 - Message
field7 - Not defined
field8 - Not defined
field9 - Optional registration field ( blank 1 )
field10 - Optional registration field ( blank 2 )
field11 - Drop Down value
field12 - Nummber input
field13 - Not defined
field14 - User selection
field15 - User optin
field16 - Checkbox
field17 - Donation Amount

Show events with no attendees

Option show_events_with_no_attendees=true setting this will display all events requested, even without attendees. If not set only events with attendees will show.

Show only future events

Option future_events=true setting this will limit events to events with a start later than now

Show only past events

Option past_events=true setting this will limit events to events with a start earlier than now

Show to logged in users only

Option logged_in_users=true setting this mean that output will only be displayed to logged in users. As the shortcode can display personal information either use this option or set other forms of page protection.

Single ID

Option id='event id' will list attendees of the single event is specified e.g. [qemreport event='234']

Sort by Title or Date

Option listby='date|title' will set the sort by date or title e.g. [qemreport listby='date'] or [qemreport listby='title']

Sort Order

Option order='ASC|DESC' will set the sort order e.g. [qemreport order='ASC'] or [qemreport order='DESC']

Was this helpful?

Next Article