Adding a Query
To add a query, select the Add Query option from the queries page and you will be presented with the query detail.
Select the boolean operator for the query clause, the field, comparison operator and value to compare. Click add clause to add a new query clause and remove to remove the last added query clause.
To save the query, enter a name and select if you would all uses to access this query or just you that can access it.
To test the query, select the perform query option to verify you are getting the results you would like.
Editing a Query
To edit an existing query , select the query from the drop down list and select the edit query option. You can then edit the query clauses, name and if the query can be run for all users. Save the query when you are finished making changes.
Delete a Query
To delete a query, select it from the drop down list and select the delete query. Confirm the delete if you are sure you want to delete the query.
||The AND operator displays a record if both the first condition AND the second condition are true.
||Same as the AND operator but used for starting grouping a clause
||The OR operator displays a record if either the first condition OR the second condition is true.
||Same as the OR operator but used for starting a grouping clause
||The AND operator displays a record if both the first condition AND the second condition are false.
||The OR operator displays a record if either the first condition OR the second condition is false.
||Used for ending a grouping clause
||The like operator uses a SQL like syntax for matching like fields. Please refer to the
SQL Wildcards syntax for more info on using the LIKE syntax.