Query Condition Types

You use query conditions when creating and running queries. For each condition you select for your query, you 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

• Single option

• Multiple option

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.

Related Topics

Query Conditions

Queries