About Filter Conditions
For searches, different filter conditions are available depending on the data type of the search field, as shown in the following table.
Data Type
|
Filter Conditions Available
|
Number, Integer, Percent, Currency
|
- Between
- Equal to
- Greater than
- Less than
- Is NULL
- Is not NULL
- Not equal to
- Not Between
|
Date, Time
|
- Between
- Equal to
- In the last 90 days
- In the next 90 days
- On
- On or after
- On or before
- Today *
- Yesterday*
- Tomorrow*
- In the last ? day
- In the next ? day
- Last Week*
- Next Week*
- This Week*
- Last Month*
- Next Month*
- This Month*
- This Quarter*
- Last Quarter*
- Next Quarter*
- This Year*
- Next Year*
- Last Year*
- Is NULL*
- Is Not NULL*
- Not equal to
- Not Between
For conditions marked with an asterisk (*), the value field is disabled when the condition is selected.
For the condition In the last ? day, and In the next ? day, the variable ? is substituted with a number of days selected in the filter value field.
|
Checkbox
|
|
Picklist
|
- Contains all values
- Contains at least one value
- Contains none of the values
- Equal to
- Is NULL
- Is not NULL
- Not equal to
|
Text
|
- Between
- Contains all values
- Contains at least one value
- Contains none of the values
- Equal to
- Greater than
- Less than
- Is NULL
- Is not NULL
- Not equal to
- Begins with
- Does not begin with
- Is Like
- Is not Like
- Not Between
|
Phone
|
- Begins with
- Between
- Contains all values
- Contains at least one value
- Contains none of the values
- Equal to
- Greater than
- Less than
- Not equal to
|
How Filter Conditions Are Used
The following table shows how various filter conditions and operators are used:
|
|
|
|
Use This
|
With
|
To Match
|
For These Results
|
Between
|
Numbers or dates
|
Two values separated by commas
|
Displays records with values between A and B (excludes values equal to A and B).
|
Contains all values (equal to)
|
Text, numbers, or dates
|
Single or multiple values separated by commas
|
Displays records matching the exact values. The application does not retrieve substrings of the values, or the same value with different capitalization (uppercase or lowercase).
|
Contains at least one value
|
Text only
|
Single or multiple values separated by commas
|
Displays records that partially match the values (allows substring matching). For example, entering Brown retrieves records with Browns Trucking, Browning Equipment, and Lester Brown Car Wash.
NOTE: This behavior applies to filtered lists only, and not to other areas in Siebel CRM On Demand that use the condition Contains At Least One Value.
Also, using this condition affects the speed at which the records are retrieved, because the system looks for partial matches.
|
Contains none of the values (not equal to)
|
Text, numbers, or dates
|
Single or multiple values separated by commas
|
Displays records not matching the values. This is the inverse of Contains all values.
|
Equal to
|
Text, numbers, or dates
|
Single value for each line. To add values, use the operator OR and add another line.
|
Displays records matching the values.
|
Greater than
|
Numbers or dates
|
Single value
|
Retrieves records with a value greater than the entered value.
|
Less than
|
Numbers or dates
|
Single value
|
Retrieves records containing a value less than the entered value
|
Operator
|
AND
|
Text, numbers, or dates
|
Two or more conditions
|
Displays records for which all given conditions are true.
For example, entering Close Date > 10/01/2003 AND Revenue > 500000 will return records that match both criteria.
|
OR
|
Text, numbers, or dates
|
Any condition
|
Displays records for which at least one condition is true.
For example, entering Industry = Energy OR Billing State=CA returns records that match either of these criteria.
|
|