Using the query builder is a quick and easy way of making queries.
It uses simple drop down menus to let you choose which tables and fields you want to apply conditions to.
Any changes you make in the query builder are reflected in the SQL Editor below this, and you can make changes directly in the SQL Editor if you prefer to write SQL.
The first condition is based on how all conditions are chosen.
all: Records meeting all of the conditions (logical AND)
any: At least one of the conditions is met (logical OR)
none: Record rejected if one of the conditions is met (logical AND-NOT)
Not all: Record included in result if at least one condition is false. If all of them are met, the record is rejected (logical OR-NOT)
Choose the fields to apply the query values for:
Choose an appropriate operator for the records
Enter a parameter you want to use for this query. This can either be a set Value, a Custom User Field, a date or a Boolean value. User Input is used if you need your users to enter a value from their mobile phone. You can have multiple User Input fields but the end user must enter them in the order specified in the query.
Clicking on a row number gives a menu to bracket groups of conditions, and to delete or disable a row.
Click Save to save the query. The result will update the SQL language as shown below. The SQL can be edited directly.
Click the Query Result tab to view the test results.
