according to the following criteria.
criteria depend on the field type (Date, Decimal, Value List, String, or
Date, the options available in Date Range filter are
predefined. Using the Date Range drop-down list, select from Custom, Today,
Yesterday, This Week, Last Week, This Month, Last Month, Year to Date, or Last
Custom will allow the user to customize the Calendar, Time Range and Days
certain days of the week.
Decimal, to specify any value or to select an
Operator from Equal To, Not Equal To, Less Than, Less Than or Equal To, or
Greater Than and then entering a value; for example, Operator = Greater Than
and Value = 16.5.
String, to specify any value or to filter by
selecting an Operator from Equal To, Not Equal To, or Matches and then enter a
value for the string; for example, Operator = Matches and Value = Team Green.
select Matches as the Operator, you must specify an SQL pattern to match the
string field. The system appends the wild card character % automatically to the
beginning and end of the string. You can also use any SQL wild card pattern in
between the string.
Boolean, to specify any value or to filter by
selecting an Operator and then selecting True or False.
- If the individual filter
field is a
Value List, to specify any value or to filter by
moving one, all, or some items in the list to the Selected column.