Queries - Clauses

All Modules | View Queries tab | Add or Edit | Clauses tab

On the Clauses tab, you set the conditions that a record must meet to be included in the Query. For example, Position Code is equal to "RETAIL".

You can use the following operators in a query.

Is equal to	=
Is less than	<
Is greater than	>
Is less than or equal to	<=
Is greater than or equal to	>=
Is not equal to
Is between	The field value is between the two values specified
Is not between	The field value is not between the two values specified
Is empty	The field is empty or blank
Is not empty	The field is not blank
Is one of	The field is one of the values specified
Is not one of	The field is not one of the values specified
Begins with	The records whose fields begin with
Does not begin with	The field value begins with this
Contains	The field value contains this
Does not contain	The field does not contain this value

When you create a query for a date field, you can use date operators to create queries such as:

Start date is in the last weeks 52 (display employees who started working in the previous 52 weeks)
Date of birth month of year is equal to 2 (display employees who have birthdays in February).

You can use the following operators that are based on today:

For example, if today is 01/08/2011 you can now create the following types of employee queries with one clause:

To display employees whose planned termination date is 31 days from today (01/09/2011):
"Planned termination date is equal to today by 31".
To display employees whose planned termination date is on or after 01/09/2011:
"Planned termination date is greater than or equal today by 31".
To display employees who were terminated on or before 01/07/2011:
"Termination date is less than or equal today by -31".

You need to use two clauses to define a range:

To display employees whose planned termination date is in the range from today to 31 days in the future:
"Planned termination date is greater than or equal today by 0" and "Planned termination date is less than or equal today by 31"
To display employees who were terminated in the range from yesterday to 31 days in the past:
"Termination date is less than or equal today by -1" and "Termination date is greater than or equal today by -31"