example with NinjaTables Pro
Thinking I can generate some simple tabled reports protected by Role with NinjaTables Pro…
How can I find and define the other calls I want to make to MySQL to get fields shown throughout EE?
Looking for:
MAX number
ACF seminar_number
Title
Ticket Details Sold Quantity
Better yet, how can I find these MySQL table and column?
ACF seminar_number would be in wp_postmeta, in Max number is a custom field, it will be in wp_postmeta too.
event title would be in wp_posts
ticket details, sold, and quantity would all be in wp_esp_ticket.
If you have phpmyadmin installed on your server you can browse the tables and columns.
Viewing 1 reply thread
The support post ‘Creating tabled reports from MySQL queries’ is closed to new replies.
Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.
Support forum for Event Espresso 3 and Event Espresso 4.