|
Gaviny
|
June 14, 2016 at 7:06 am
Hi all, I think i have asked something along these lines before, but i dont think i asked about this specifically.
I’ve been building some reports in MS Power BI to reflect how many people attend and how many have paid and such. What i would like to do is filter this by the individual ‘coach’ but i cant find where it is stored in the database.
I remember something about the WP_USERS table but cant seem to find it there. I imagine i would need to reference WP_USERS user id somewhere with EE but im not sure where.
Which table(s) would i need for this? i’ve managed to find everything else i needed.
Regards,
Phil
|
|
Josh
|
June 15, 2016 at 6:12 pm
Hi Phil,
I’m not clear on how you have the events set up with their own event managers. Are these the authors of the events or is this something you’ve set up with the EE4 People add-on?
|
|
Gaviny
|
June 17, 2016 at 3:20 am
Hi sorry for the delay.
I have used the People Addon to create the coaches. The event author is one person who has asked to be the author so he can check registrations as it is his company.
If its the people addon would it be a custom post type in my wp_posts table?
Phil
|
|
Lorenzo Orlando Caum
|
June 17, 2016 at 7:37 am
Hi Phil,
People are stored as custom post types in the wp_posts database table. The custom post type is:
espresso_people
—
Lorenzo
|
|
Gaviny
|
June 20, 2016 at 2:04 am
Thank you Lorenzo. Im starting to understand the database a bit more now. Its getting easier. Thank you.
Regards
Phil
|
