Is it possible to somehow modify WP-DataTables so that my posts along with their custom field data are displayed in an updating WP-Data Table?
Normally WordPress displays all posts in a blog like format, but I have a client that desperately wants to have all posts (millions of them) displayed in a WP-Data Table that can filter, sort, etc...
Hi Dan, Thank you for your interest in wpdatatables.
WordPress and its plugins store the data in a specific MySQL database, usually referred to as “WPDB”. The structure familiar to users, is based on different post types, post custom (meta) fields, and taxonomies; all stored in a collection of MySQL tables. Querying these elements, however might be somewhat of a headache to someone not that familiar with relative database structures and building SQL queries.
wpDataTables has a built-in WPDB query constructor to help those users. It has a graphical user interface which allows a user to pick the post types, custom/meta fields, and taxonomies, and generates a query and a preview. You can modify the query as needed, and create a wpDataTable based on the modified query.
Yes it will be updated if you made query (by yourself or with query builder) that will return all posts from database. You can try that in our sandbox by creating table with Create a MySQL-query-based table by generating a query to WordPress database choosing post from All post types and some post properties. After that add new post with some dummy data and after that check your table and you will see that is updated with all posts from database. (including new one)
Is it possible to somehow modify WP-DataTables so that my posts along with their custom field data are displayed in an updating WP-Data Table?
Normally WordPress displays all posts in a blog like format, but I have a client that desperately wants to have all posts (millions of them) displayed in a WP-Data Table that can filter, sort, etc...
Hi Dan,
Thank you for your interest in wpdatatables.
WordPress and its plugins store the data in a specific MySQL database, usually referred to as “WPDB”. The structure familiar to users, is based on different post types, post custom (meta) fields, and taxonomies; all stored in a collection of MySQL tables. Querying these elements, however might be somewhat of a headache to someone not that familiar with relative database structures and building SQL queries.
wpDataTables has a built-in WPDB query constructor to help those users. It has a graphical user interface which allows a user to pick the post types, custom/meta fields, and taxonomies, and generates a query and a preview. You can modify the query as needed, and create a wpDataTable based on the modified query.
You can read more in our documentation about Create a MySQL-query-based table by generating a query to WordPress database.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Perfect, but will the table update every time I post a new post?
Hi Dan,
Yes it will be updated if you made query (by yourself or with query builder) that will return all posts from database. You can try that in our sandbox by creating table with Create a MySQL-query-based table by generating a query to WordPress database choosing post from All post types and some post properties. After that add new post with some dummy data and after that check your table and you will see that is updated with all posts from database. (including new one)
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Thank you so much! You can close this ticket now.
Hi Dan,
You are welcome.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables