How can i have multiple queries for each column in a custom list table when using wp-list-table function?
I am building a custom page by using wp-list table class which will display a list with lets say 5 columns.
According to the wordpress codex, I will need to handle data by using Functions Prepared(Items) with an sql query to retrieve data from the database. I would like to know if i can use a different query for each of this columns.
$query = "SELECT ID, post_title, branch, week, donation, attendance, payments,post_date FROM $wpdb->posts, $wpdb->postmeta WHERE $wpdb->posts.ID=$wpdb->postmeta.post_id AND post_type = 'manufacturing' AND post_status = 'publish' ORDER BY post_date"; $data = $wpdb->get_results($query, ARRAY_A);
The above will get data for all columns at once but i want to use special queries for each column.
Secondly, if I have a custom filter for a post list table for a custom post type, after applying the filter , I want each column to display a result ( this result ..each column will be based on specific queries).
I mean -- each column after the filter query will be result from a specific query for each column.