Hi - is there a way I can use SQL to get my table data, but then insert a column with dynamic cell values, using a PHP function? I can't do the calculation in SQL because it depends on current logged-in user role and other user metadata. But I gather wpdatatables_filter_columns_data doesn't work if I'm using SQL to get the data, is that right?
An example: let's say I'm pulling out a table of records post type of post type "person", and then I want to insert a column called "Entries" which counts up Gravity Form entries where that person is selected in field 1. But I only want to include entries where field 2 has the ID of the post type "company" which is also associated with the current user. Hope I'm making sense!
Hi - is there a way I can use SQL to get my table data, but then insert a column with dynamic cell values, using a PHP function? I can't do the calculation in SQL because it depends on current logged-in user role and other user metadata. But I gather wpdatatables_filter_columns_data doesn't work if I'm using SQL to get the data, is that right?
An example: let's say I'm pulling out a table of records post type of post type "person", and then I want to insert a column called "Entries" which counts up Gravity Form entries where that person is selected in field 1. But I only want to include entries where field 2 has the ID of the post type "company" which is also associated with the current user. Hope I'm making sense!
Thanks very much.