Okay
  Public Ticket #3104248
relationships between 2 posts type
Closed

Comments

  • Persia Joffrey started the conversation

    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

  •  1,851
    Miloš replied


    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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