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?
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...)
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
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
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...)
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.
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