Print      Open PDF Version of Online Help


Previous Topic

Next Topic

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

  • Is checked
  • Is not checked

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 Oracle 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 Oracle CRM On Demand 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.


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.