|
ICLE
|
January 27, 2020 at 11:33 am
I am attempting to make some simple reports in NinjaTables Pro with data from Event Espresso with “Dynamic Post Data Settings”.
How do I find the post meta values to add to create the column for “category”?
|
|
Josh
|
January 27, 2020 at 11:42 am
Hi,
May I ask what kind of data are we talking about? Most of Event Espresso’s event and registrant data isn’t stored in post meta, they’re stored in custom tables. If you look in the database (with a tool like phpmyadmin) you’ll find the data in tables prefixed with
esp.
|
|
ICLE
|
January 27, 2020 at 11:46 am
Ninjatables has a way of posting the following field types:
Advanced Custom Fields (ACF) (I’ve done this and it rocks)
*Post Meta
*Shortcode / Computed Value or HTML
Featured Image (this type of data is not of concern)
*Are there values from EventEspresso for these field types? I’m trying to get ahold of the category values.
|
|
Josh
|
January 27, 2020 at 12:32 pm
A category value is a WordPress taxonomy value. That’s stored in the wp_term_relationships and wp_term_taxonomy tables. You could check with Ninjatables pro support to see if they support data from those tables.
|
|
ICLE
|
February 3, 2020 at 2:50 pm
The support over at Ninjatables Pro said they support WP hooks. Where do I start with that bit of information?
|
|
Josh
|
February 3, 2020 at 3:02 pm
You could ask them where they have documentation about that. I’m afraid that’s a bit too little of information to go on.
|
|
ICLE
|
February 3, 2020 at 3:03 pm
They gave me this example:
<?php
/*
* Say we want to change data of table id 1477 then you can write the following
* code.
* $data is the array of frontend data
*/
add_filter(‘ninja_tables_get_public_data’, function ($data, $tableId) {
if ($tableId == 1477) {
$data[] = [
‘name’ => ‘Dynaic Name’,
’email’ => ‘my@dyne.com’,
‘phone’ => ‘983129123123’
];
}
return $data;
}, 1
|
|
Josh
|
February 3, 2020 at 3:16 pm
That’s not much of a helpful example because it doesn’t show how to grab taxonomy data for the post.
I’ll be honest with you, I’ve never used NinjaTables so I don’t know what it does or how it works. From what you’ve posted here though, it doesn’t sound like it supports getting taxonomy related data (only post meta data).
|
