There is lots going on and lots to post about, but it's been busy. So, for the moment, I just want to post something quick about how to navigate a not very friendly feature in CE.
First, however, I want to mention that we are about to implement a much friendly solution, which I will blog about soon.
The problem is how to get clean event registration reports out of the Reports module.
You can already get these, or course, out of the Events module. Just go to an event as an admin and there are a list of pre-built reports like:
Completed Registrations
Pending Registrations
etc.
But, if you wanted to generate the same or similar reports in the Reports module, you have to know which filters to use to exclude unwanted data like incomplete registrations, deleted registrations and so forth. It's pretty easy if you know which filters to apply but it's not as obvious as it should be. So, here are some key examples.
Completed Registrations for an event:
- filter on the eventid to make sure that you are just focusing on the event that you want data for (e.g. "Eventid equals 18).
- filter on the Order "Process Date" field for not null values (e.g. "Process Date not Null")
Incomplete Registrations for an event:
- filter on the eventid to make sure that you are just focusing on the event that you want data for (e.g. "Eventid equals 18).
- filter on the Order "Process Date" field for null values (e.g. "Process Date is Null")
- filter on the "Order ID" field for not null values (e.g. "Order ID not Null")
That's it.
Soon we will add a simple registration status field that will be easier to use. More on that soon!