Display SQL Query Results?

  • Resolved junket1234

    (@junket1234)


    8 months, 2 weeks ago

    I’ve used the SQL Query Builder to make a sweet table of concatenated data (drawing on four tables), and I need to be able to make this available on the front end… but I see no shortcode option or any other way to do that.

    Am I missing something totally obvious?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    8 months, 2 weeks ago

    Hi @junket1234

    Thank you for reaching out.

    The Query Builder does not have any shortcodes. You can make a database view for your query and use your view in the App Builder. Similar to database tables, database views can be used with the App Builder.

    TIP Be sure to enter CREATE OR REPLACE VIEW in the Query Builder rather than CREATE VIEW. As a result, you can save your query and run it as often as you like.

    The MySQL documentation for views is available here:
    https://dev.mysql.com/doc/refman/8.4/en/create-view.html

    Hope this helps,
    Peter

    Thread Starter junket1234

    (@junket1234)

    8 months, 2 weeks ago

    Thanks for the reply!

    OK, interesting — I had that idea, actually, and created a db view with the query … but I assumed that since the App Builder wizard only showed “tables” as an option, my new view wasn’t there. It was.

    That works.

    • This reply was modified 8 months, 2 weeks ago by junket1234.
    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    8 months, 2 weeks ago

    OK, I see how such a prompt can be misleading. We’ll fix that with the next update.

    Thank you for reporting back! 🙏

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Display SQL Query Results?’ is closed to new replies.