- Contents
Exchange Manager Help
Query Condition Types
You use query conditions to specify the criteria to use to evaluate accounts. The criteria available is based on the condition type.
Each condition is one of the following types:
Dates
Date conditions allow you to query accounts based on a specific date, date range, any date or blank date, or relative date. When you select a date condition, a dialog box displays to allow you to specify the date criteria. The criteria available depends on the value you select in the Value is list box, and whether you select the Relative check box.
Specific date
Use one of the following comparisons to evaluate accounts based on a specific date:
|
Value is |
Description |
|
Equal To |
Retrieves accounts where the date matches a specific date. |
|
Not Equal To |
Retrieves accounts where the date does not match a specific date. |
|
Later Than or Equal To |
Retrieves accounts where the date matches or comes after a specific date. |
|
Earlier Than or Equal To |
Retrieves accounts where the date matches or comes before a specific date. |
|
Later Than |
Retrieves accounts where the date comes after a specific date. |
|
Earlier Than |
Retrieves accounts where the date comes before a specific date. |
In the following example, the system retrieves accounts where the Closed Date is 01/01/2012.
Date range
Use one of the following comparisons to evaluate accounts based on a date range:
|
Value is |
Description |
|
Between |
Retrieves accounts where the date falls between two specific dates. |
|
Not Between |
Retrieves accounts where the date comes before a specific start date or after a specific end date, but not between the two dates. |
In the following example, the system retrieves accounts where the Closed Date falls on or between 01/01/2012 and 02/01/2012.
Any date or blank date
Use one of the following comparisons to evaluate accounts based on whether a date is blank or contains any value:
|
Value is |
Description |
|
No Value |
Retrieves accounts where the date is blank. |
|
Any Value |
Retrieves accounts where the date is any date or blank. |
In the following example, the system retrieves accounts where the Closed Date is blank (doesn't contain a value).
Relative date
Use the relative date option to evaluate accounts based on the relation of a date to the current date. You specify a comparison and the criteria to use to calculate the relative date. The criteria are the number of days, months, or years from the current date, and whether to add or subtract that number from the current date.
Use one of the following comparisons to evaluate accounts based on the calculated relative date:
|
Value is |
Description |
|
Equal To |
Retrieves accounts where the date matches the relative date. |
|
Not Equal To |
Retrieves accounts where the date does not match the relative date. |
|
Later Than or Equal To |
Retrieves accounts where the date matches or comes after the relative date. |
|
Earlier Than or Equal To |
Retrieves accounts where the date matches or comes before the relative date. |
|
Later Than |
Retrieves accounts where the date comes after the relative date. |
|
Earlier Than |
Retrieves accounts where the date comes before the relative date. |
In the following example, the system retrieves accounts where the Closed Date is two days before the current date.
Single option
Single option conditions allow you to retrieve accounts that match a single option in a group of options. In the following example, the system retrieves accounts that are the parent link to other accounts.
Multiple option
Multiple option conditions allow you to retrieve accounts that match one or more options in a group of options. In the following example, the system retrieves accounts assigned to the POD desk and accounts assigned to the POOL desk.
