Support

Home Forums Event Espresso Premium Creating tabled reports from MySQL queries

Creating tabled reports from MySQL queries

Posted: July 11, 2019 at 1:13 pm

Viewing 1 reply thread


ICLE

July 11, 2019 at 1:13 pm

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?


Josh

  • Support Staff

July 11, 2019 at 1:23 pm

Hi,

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.

Event Espresso