Select Query

Use this query type when you need to select data in MySQL database.

When building Select Query be careful and always us a Display condition to limit the number of rows returned by the query because too many unwanted rows can make your web app slow.

Here all that one needs to do is select a table in the Left panel and then click the tiny + sign on the left of selected table. This will open a list of fields in the table.

Now depending on your needs select the fields that you want to retrieve from database and click on the right arrow button located between Table list and Item list. This will add selected field to Item list.

Once all the required fields are selected you can set sort order for one or more fields. Decide which fields will show up in the query result.

Finally click on the Save button to save your query and generate Web-service for that query.