We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #1033454
SQL queries
Closed

Comments

  •  2
    BeeKeeper65 started the conversation
    January 24, 2017 at 4:31am

    When I create an SQL query can I edit the text in the preview box to create a different query. Like using COUNT to give a total number. I am getting errors when trying this on my table, the tables aren't loading on preview.


    Also, when I'm creating a new record in the front end editor, it will automatically have selected one of multiple options. How do I have no options selected?


    Thanks

  • [deleted] replied
    January 24, 2017 at 3:23pm

    Hi BeeKeeper65,

    If you are changing query you need to hit save button after every change. If you have plans to use functions or variables in your query we strongly recommend to create MySQL VIEW  from your query and use that as data source. 

    Please tell me do you want what is editor input type name that you refer to (single-value, multi-value...)

  •  2
    BeeKeeper65 replied
    January 27, 2017 at 5:27am

    So I am using multi value and single value select boxes. 

    Both types, when you click +New, the box will automatically select the first option (as shown in the picture).

    What can I do in order to have nothing selected when I click +New on the front end? Thank you.

  • [deleted] replied
    January 28, 2017 at 2:41pm

    Hi BeeKeeper65,

    You can create one empty field before any others possible values by entering space and hitting enter. That way you will have empty value selected in New modal