Support for joins and other custom SQL Queries

  • Resolved rweil55

    (@rweil55)


    7 years, 1 month ago

    Ian

    I had a sql statement that included a join that I wished to use WP_Tables for display.
    I discovered that WP_Tables does not support custom SQL queries.
    I found a work around. Please add the following statement to the documentation.
    When you get around to the major documentation, you might include a section on syntax for creating a view

    “WP_Tables does not directly support custom SQL queries, However if you use phpMyAdmin to create a view, then WP_Tables can display that view.”

    Roy

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Ian Sadovy

    (@iansadovy)

    Hello @rweil55,

    Thank you for writing.
    Actually, WPTables supports custom MySQL queries starting from version 1.3.2.
    Does it work for your case or your suggested workaround works better?

    Regards,
    Ian

    Thread Starter rweil55

    (@rweil55)

    Not sure what I did wrong. When I tried the join sql the first time, it returned the fields for the table that was specified, rather than the fields of the select statement. I just tried it again, and this time it worked as expected. (it returned the fields of the join)

    You might want to put something in the document about views.
    i.e.
    “Need to insert a table/view into your page or post?”

    Plugin Author Ian Sadovy

    (@iansadovy)

    Hello @rweil55,

    Thank you for the answer.
    As for the views, I will try to add your suggestion somewhere in the docs.

    Regards,
    Ian

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Support for joins and other custom SQL Queries’ is closed to new replies.