[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
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’]
Option event=’csv of ids’ will list attendees of the events is specified e.g. [qemreport event=’234,878′]
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.
Option limit=’number’ will limit the maximum events to display e.g. [qemreport limit=’3′]
Option yearnumber=’YYYY’ will just report a specific year e.g. [qemreport yearnumber=’2021′]
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
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.
Option future_events=true setting this will limit events to events with a start later than now
Option past_events=true setting this will limit events to events with a start earlier than now
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.
Option id=’event id’ will list attendees of the single event is specified e.g. [qemreport event=’234′]
Option sort_attendees_by=’surname|email|date_asc|date_desc’ will sort attendees within an event by the option e.g. [
Registrations Listed by Event
Option listby=’date|title’ will set the sort by date or title e.g. [qemreport listby=’date’] or [qemreport listby=’title’]
Option order=’ASC|DESC’ will set the sort order e.g. [qemreport order=’ASC’] or [qemreport order=’DESC’]