Using out-of-the-box queries: Events
Using out-of-the-box queries: Events
The following are out-of-the-box queries related to events, organized by category. Use these predefined queries to easily retrieve event data.
BASIC DATA
| Query | Purpose | Location in Document System | Location in iMIS |
|---|---|---|---|
| Event Details - Recent and Upcoming | Displays recent or upcoming events including Start Date, City, Total Registrants, and other pertinent details. | $/Samples/Dashboards/Events | Events dashboard Recent and upcoming tab |
| Event registrations | Displays event registration list and attendee search. | $/Samples/Dashboards/Events | Events dashboard (Events > Dashboard) |
| Program item registrations | Displays program item registration list and attendee search. | $/Samples/Dashboards/Events | Events dashboard |
| Progress Tracker - Event Registrations Last Year | Tracks event registrations from the previous year. | $/Samples/Dashboards/Events | Events dashboard |
| Progress Tracker - Event Registrations This Year | Tracks event registrations from the current year. | $/Samples/Dashboards/Events | Events dashboard |
| Progress Tracker - Event Revenue This Year | Tracks event revenue from the current year. | $/Samples/Dashboards/Events | Events dashboard |
| Progress Tracker - Program Item Registrations This Year | Tracks program item registrations from the current year. | $/Samples/Dashboards/Events | Events dashboard |
| Registrations by Event This Year | Displays registrations for events happening in the current year. | $/Samples/Dashboards/Events | Events dashboard |
| Revenue by Event This Year | Displays revenue data for events happening in the current year. | $/Samples/Dashboards/Events | Events dashboard |
| Scheduled Events | Displays a list of current scheduled events. | $/Samples/Dashboards/Events | Events dashboard |
| Total Event Registrations by Member Type | Displays the current year's event registrations broken down by registrant member types. | $/Samples/Dashboards/Events | Events dashboard |
| Top Events | Displays a list of the top events of the year. | $/Samples/Dashboards/Events | Events dashboard Top events tab |
| All event functions | Displays functions for all events, including registration options and program items. | $/Common/Query Sources/Events | Event showcase tab |
| Event registration data | Displays all event registration data. | $/Common/Query Sources/Events | Event dashboard tab |
| Events list | Displays all events. | $/Common/Query Sources/Events | Events search |
| By speaker | Displays who is scheduled to speak at an event. | $/Samples/Dashboards/Events/Specific Events/Speakers | Event dashboard tab |
| Specific Event | Displays specific events including registrants for each event, along with the registration date and order number. | $/EventManagement/DefaultSystem/Queries/Advanced/Event | Dashboard tab of specific events |
ATTENDEE DATA
| Query | Purpose | Location in Document System | Location in iMIS |
|---|---|---|---|
| Annual Conference Event Sessions | Displays Annual Conference event sessions. | $/Samples/Events | Annual Conference event |
| Event Attendees | Displays attendees who went to an event. | $/Samples/Events | Specific event page |
| Event question responses | Displays responses to questions asked of registrants for an event. | $/Samples/Events | Event questions tab |
| Event questions with no responses | Displays a list of event registrants who have not responded to questions for the event, program item, or admission options. | $/Samples/Events | Questions tab > specific question > Registrants with no response tab |
| Single Upcoming Event | Displays one-time events on the Member Responsive homepage. | $/Samples/Events | Member site > Events > Event List |
| Upcoming Events | Displays upcoming events on the Member Responsive homepage. | $/Samples/Events | Member site > Events > Event List |
| Registered Event | Displays registered events. | $/EventManagement/DefaultSystem/Queries/Attendance | Find registrations page |
| Registered | Displays contacts who are registered for an event. | $/EventManagement/DefaultSystem/Queries/Attendance | Find registrations page |
| Event function registrations | Displays event function registrations including registration options and program items. | $/Common/Query Sources/Events | Update attendance |
REGISTRATION
| Query | Purpose | Location in Document System | Location in iMIS |
|---|---|---|---|
| Registration option registrations | Displays contact registrations for specific registration options. | $/Common/Query Sources/Events | Event registrants tab |
| Registration options | Displays registration options for contacts to select. | $/Common/Query Sources/Events | Showcase tab of specific events |
| Active registrations | Displays active registrations for a specific event. | $/Samples/Dashboards/Events/Specific Events/Registrants/Event registrations | Event registration |
| Cancelled registrations | Displays cancelled registrations. | $/Samples/Dashboards/Events/Specific Events/Registrants/Event registrations | Event registration |
| Promotions used | Displays promotions used by registrants for a specific event. | $/Samples/Dashboards/Events/Specific Events/Registrants/Event registrations | Event registration |
| Active registrations with a balance | Displays active registrations that need to be paid for in full for a specific event. | $/Samples/Dashboards/Events/Specific Events/Registrants/Event registrations | Registration tab of specific events |
| Waitlist for registration options | Displays registrants who are waitlisted for specific registration options for a specific event. | $/Samples/Dashboards/Events/Specific Events/Registrants/Event registrations | Registration tab of specific events |
| Previously Registered Event Guests | Displays guests previously registered for events. | $/EventManagement/DefaultSystem/Queries/Advanced/Event | Registration tab of specific events |
| Registrant Search | Search function for event registrants. | $/EventManagement/DefaultSystem/Queries/Advanced/Event | Registration tab of specific events |
| Specific registrations | Displays specific registrations. | $/EventManagement/DefaultSystem/Queries/Advanced/Event | Find registrations |
| Speakers | Displays which speakers are scheduled to speak at various events. | $/EventManagement/DefaultSystem/Queries/Register multiple | Plan tab on specific events |
| All event registrations | Displays event registrations for all events to be used when issuing event confirmations. | $/EventManagement/DefaultSystem/Queries/Registration confirmations | Issue event confirmations |
| Registrations with email | Displays all registrations who entered emails when registering for events to be used when issuing event confirmations. | $/EventManagement/DefaultSystem/Queries/Registration confirmations | Issue event confirmations |
| Registrations without email | Displays all registrations who did not enter emails when registering for events to be used when issuing event confirmations. | $/EventManagement/DefaultSystem/Queries/Registration confirmations | Issue event confirmations |
| Badge Information | Displays badge information for attendees. | $/EventManagement/DefaultSystem/Queries/Registration details | View registration on the Registrants tab |
| Program Item Registrations | Displays program item registrations a specific registrant is registered for. | $/EventManagement/DefaultSystem/Queries/Registration details | View registration on the Registrants tab |
| Question Responses | Displays responses to questions for an event a specific registrant is registered for. | $/EventManagement/DefaultSystem/Queries/Registration details | View registration on the Registrants tab |
| Registration Billing Information | Displays billing information provided by contacts when registering for events. | $/EventManagement/DefaultSystem/Queries/Registration details | View registration on the Registrants tab |
| Registration Details | Displays registration details. | $/EventManagement/DefaultSystem/Queries/Registration details | View registration on the Registrants tab |
| Registration Invoices | Displays registration invoices for specific events a registrant is registered for. | $/EventManagement/DefaultSystem/Queries/Registration details | View registration on the Registrants tab |
| Registration Option | Displays registration options a specific registrant is registered for. | $/EventManagement/DefaultSystem/Queries/Registration details | View registration on the Registrants tab |
| Registration Status | Displays registration statuses of registrants. | $/EventManagement/DefaultSystem/Queries/Registration details | View registration on the Registrants tab |
PROGRAM ITEMS
| Query | Purpose | Location in Document System | Location in iMIS |
|---|---|---|---|
| Program items | Displays all program items, active and inactive. | $/Common/Query Sources/Events | Showcase tab of specific events |
| Active program item registrations | Displays registrations for active program items for a specific event. | $/Samples/Dashboards/Events/Specific | Registration tab of specific events |
| Cancelled program item registrations | Displays cancelled registrations for program items for a specific event. | $/Samples/Dashboards/Events/Specific/Events/Registrants/Program items | Registration tab of specific events |
| Waitlist for program items | Displays registrants who are waitlisted for specific program items for a specific event. | $/Samples/Dashboards/Events/Specific/Events/Registrants/Program items | Registration tab of specific events |
| Program items registrations | Displays contact registrations for specific program items. | $/Common/Query Sources/Events | Registration tab of specific events |
| Program items | Displays guests who are scheduled for specific program items. | $/Samples/Dashboards/Events/Specific Events/Speakers | Dashboard tab Program items tab of specific events |
CANCELLATIONS
| Query | Purpose | Location in Document System | Location in iMIS |
|---|---|---|---|
| Cancelled | Displays contacts who have cancelled their registrations. | $/EventManagement/DefaultSystem/Queries/Attendance | Find registrations |
INVOICE DATA
| Query | Purpose | Location in Document System | Location in iMIS |
|---|---|---|---|
| Event invoice lines | Displays event invoice information. | $/Common/Query Sources/Events | Event dashboard tab |
| All invoices | Displays all invoices for specific events. | $/Samples/Dashboards/Events/Specific Events/Invoices | Event dashboard tab |
| Open invoices | Displays all open invoices for specific events. | $/Samples/Dashboards/Events/Specific Events/Invoices | Event dashboard tab |
WAITLISTS
| Query | Purpose | Location in Document System | Location in iMIS |
|---|---|---|---|
| Waitlisted | Displays contacts who have been waitlisted for events. | $/EventManagement/DefaultSystem/Queries/Attendance | View waitlist |
EVENT QUESTIONS
| Query | Purpose | Location in Document System | Location in iMIS |
|---|---|---|---|
| Event question details | Query used in Event reports that include details on event questions. | $/Samples/Dashboards/Events/Specific Events/Reports | Events dashboard |
| Event question responses | Query used in Event reports that include responses to event questions. | $/Samples/Dashboards/Events/Specific Events/Reports | Events dashboard |
| Event question responses by question | Query used in Event reports that include responses to questions filtered by the question. | $/Samples/Dashboards/Events/Specific Events/Reports | Events dashboard |
| Responses by question chart | Query used in Event reports that can be used to create visual charts. | $/Samples/Dashboards/Events/Specific Events/Reports | Events dashboard |