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.

You must be logged in to reply to this support post. Sign In or Register for an Account

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: publish

Updated by  Josh 1 week ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!