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


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.

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.
Documentation for EE3 and EE4
Documentation for Event Espresso 3 Documentation for Event Espresso 4

Status: closed

Updated by  Josh 4 years, 9 months ago ago

Topic Tags

Notifications

This topic is: not resolved
Event Espresso