Okay
  Public Ticket #1216516
creating sql table stuck
Closed

Comments

  • iias started the conversation

    when using wpDataTable constructor to create a sql table, i'm choosing post date and post title and its stuck on the turning arrows

  •  1,846
    Miloš replied

    Hi iias,
    Thank you for your purchase.

    If you take a look at our documentation about wpdatatables constructor you will notice that constructor is just a helper.


    "Please note: to use this plugin feature you need to have at least basic knowledge of SQL, it is assumed that you can create the table in some MySQL data manager (PHPMyAdmin, MySQL Workbench) and prepare a SQL query that will return the data that you need. If you do not know how to use MySQL, refer to <a href=”/documentation/creating-new-wpdatatables-with-table-constructor/”>creating tables with Table Constructor</a> section which will explain how to create complete tables or MySQL queries without this knowledge. Please be advised that preparing MySQL queries for you is not included in plugin support, but can be done as a paid customization service."

    So when you have queries like that our suggestion is to make a VIEW in phpmyadmin or any other database management system and see if it is returning the right results. If the query is returning the desired result use that as an input for Add from data source option when creating tables.

    Best regards.

    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