Custom query hangs

  • Resolved actibus

    (@actibus)


    11 months, 2 weeks ago

    In the table builder when using a custom query like: “SELECT column1, column2 FROM table” it wont load, if I use “SELECT * FROM table” it works right away.

    What am I missing?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    11 months, 2 weeks ago

    Hi @actibus,

    To select specific columns in a table, you can do either of the following:

    SELECT table.column1, table.column2 FROM table

    OR

    wrap the column names with backticks like this: https://share.getcloudapp.com/Z4ungOYL

    This is to ensure specificity across tables in your database.

    Hope this helps! Let us know if you have more questions. 🙂

    Plugin Contributor Kim L

    (@kimmyx)

    11 months, 1 week ago

    Hi there,

    I’m going to mark this as resolved as we haven’t heard from you in a while.

    Feel free to create a new thread if you have other questions.

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Custom query hangs’ is closed to new replies.