I need to be able to display a table of datas from a custom post type (trainings) and for each post, also display the list of trainers (an other Post type).
Technically, I have linked the 2 CPT with a relationship link from ACF Pro (or it is possible do to the same with Metabox but I would rather not)
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
We currently don't have any native a built-in integration with a plugin such as ACF , or Metabox .
Pulling the data from that plugin into wpDataTables,
or generally pulling data from Custom Post Types would have to be done with MySQL query-based tables.
You can make JOINS between tables in custom SQL Queries, to load data from multiple tables.
Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need.
Please be advised that preparing MySQL queries for you is not included in the plugin support.
-
As the custom posts/fields, are a part of the WordPress database;
- Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible.
Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.
Hi,
I am building an internal website for a company.
I need to be able to display a table of datas from a custom post type (trainings) and for each post, also display the list of trainers (an other Post type).
Technically, I have linked the 2 CPT with a relationship link from ACF Pro (or it is possible do to the same with Metabox but I would rather not)
Is is possible to do that with wpdatatables ?
Thank you
Hi, Persia
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
We currently don't have any native a built-in integration with a plugin such as ACF , or Metabox .
Pulling the data from that plugin into wpDataTables,
or generally pulling data from Custom Post Types would have to be done with MySQL query-based tables.
You can make JOINS between tables in custom SQL Queries, to load data from multiple tables.
Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need.
Please be advised that preparing MySQL queries for you is not included in the plugin support.
-
As the custom posts/fields, are a part of the WordPress database;
a good way to achieve this can be experimenting using our WPDB SQL Query Constructor tool.
- Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible.
Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables