|
snradmin
|
May 23, 2019 at 5:31 pm
Similar to petranet, I am looking to avoid sending CSV reports to my fellow volunteers on a regular basis (See Custom front-end report? )
I found a solution that would allow me to update the registration data regularly that I can share securely. I need the SQL code that is generated by the RegistrationsReport.php function via show_next_x_db_queries. Is there a snippet or version of this function that only creates the SQL for RegistrationsReport.php?
|
|
Tony
|
May 24, 2019 at 5:36 am
Hi there,
I’m sorry but I’m not sure I understand what you are asking for.
There are multiple queries used to generate the registration report, for example pulling in registrations, then payments linked to the registrations, ten datetimes linked to the tickets for the registrations, then answers linked to the registration.
All of those different models so I don’t think you can use show_next_x_db_queries how I think you want to above but again, I’m not really sure I follow.
|
|
snradmin
|
May 24, 2019 at 8:15 am
If I have to use from multiple SQL calls, that is not outside the realm of possibility. How does it put all of those different queries into one CSV?
|
|
Tony
|
May 24, 2019 at 8:54 am
You can take a look within RegistrationsReport.php at the get_csv_data_for() method to see how it pulls all of the information in and combines it into an array ready for the CSV.
|
