Okay
  Public Ticket #3196118
capabilities
Closed

Comments

  • DENISE started the conversation

    I will have, at a minimum two-table database.  Is it possible to use this plugin to combine information from both tables or more?

  •  1,846
    Miloš replied


    Hi, DENISE

    Thanks for reaching out to us

    -

    Yes,  you can combine data from multiple tables in two ways.

    1. You can use our built-in feature of foreign key columns.

    More details about it here.

    2.  You can use SQL Tables and input JOINs between tables in order to join data from multiple tables.

    More details about using our SQL Tables here.

    -  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. If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge. Please be advised that preparing MySQL queries for you is not included in the plugin support.



    - * Important to note,  if you need editing,  in our plugin we can only edit one table at a time,

    so if you use our foreign key feature, editing is available , but limited to "one value selectbox";

    or if you use JOINs in SQL Query, then you will not have editing available for a table that pulls data from multiple tables.

    -

    And i just wanted to point out that you can try wpDataTables before purchasing

     on our sandbox Demo sites ( you can find links for the main plugin Demo,  

    as well as add-on Demos, in my signature),

    and there is a 15-day money-back guarantee period, 

    so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

    Let me know if you have any additional questions. smile.png

    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