The Report Console includes a simple query builder that allows you to quickly construct a simple query. By default, the report designer screen opens with the simple query builder active.
The simple query builder, with advanced query builder closed
(Click the image to expand it.)
Building a query using the simple query builder
- In the Filter By area of the report designer screen, select a field from the Available Fields list.
- Drag the field to the query area, or click Add Field.
- Select the query operator:
- Is equal to — Selects records in which the value in the chosen field matches exactly the value entered in the query.
- Is not equal to — Selects records in which the value in the chosen field does not match the value entered in the query.
- Is empty — Selects records in which the chosen field is empty.
- Is not empty — Selects records in which the chosen field contains some data.
- Is myself — Selects records in which the value in the chosen field matches the current user's login ID.
- Is not myself — Selects records in which the value in the chosen field does not match the current user's login ID.
- Is LIKE — Selects records in which the value in the chosen field matches the string defined in the query.
The LIKE operator requires that you use the percent (%) wildcard, which matches any string of 0 or more characters. For example, to get a report of classes for which Teresa Logan is the instructor, use one of the following search strings:- Teresa% matches all entries that begin with "Teresa"
- %Logan matches all entries that end with "Logan"
- T%eresa% would find entries that start with "Teresa" or "Theresa"
- Type the value to search for in the blank field.
For example, to find Teresa Logan's classes that have students enrolled, you could use the simple query builder to construct the following query:
(Click the image to expand it.)
