Queries

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.

Boolean Operators

Operator Description
AND The AND operator displays a record if both the first condition AND the second condition are true.
AND ( Same as the AND operator but used for starting grouping a clause
OR The OR operator displays a record if either the first condition OR the second condition is true.
OR ( Same as the OR operator but used for starting a grouping clause
AND NOT The AND operator displays a record if both the first condition AND the second condition are false.
OR NOT The OR operator displays a record if either the first condition OR the second condition is false.
) Used for ending a grouping clause

Comparison Operators

Operator Description
LIKE 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.

Last edited Aug 14, 2014 at 6:09 PM by dubeaud, version 3