There are two ways to display this kind of data in wpDataTables:
1. Use the WP Posts integration (no coding needed)The WP Posts Table Constructor allows you to build a table directly from your site’s WordPress content.
You can dynamically display:
Post titles, authors, categories, or publish dates
Custom fields (ACF or other post meta)
Taxonomies
And more...
This is the easiest method if you’re working with standard WordPress content types and want to build the table through the UI.
Read more:
WP Posts Table Constructor Custom Fields Integration
2. Use a Custom SQL Query (advanced)If you prefer more control or need to join additional database tables, you can create a MySQL query-based table.
Note: This feature requires basic SQL knowledge and access to tools like phpMyAdmin or MySQL Workbench.
To help you get started, you can try our visual query generator tools:
WPDB Query Constructor — focuses on querying WordPress post content
MySQL Query Builder — for broader database access
Keep in mind:
The MySQL Query Constructor is not an “ultimate generator” — it should be treated as a helper tool that offers a suggested query based on its best guess at what you’re trying to achieve.
We’re continuously working to improve it, but SQL is a complex and highly flexible language, so full automation is rarely possible.
As a result, the more complex your requirements are, the higher the chance that the generated query won’t return exactly what you need. You’ll often need to tweak and experiment with the suggested query to get the desired result.
A quick note about supportWriting or debugging custom SQL queries is not covered under our support scope.
However, we’re happy to guide you toward documentation, working examples, or general advice whenever possible.
You can also check the official WordPress Codex for tips on building custom post queries.
