Country Filter for Canada
.
The filter name appears in the Apply custom filters box
in the Section Filters dialog box.
Operator
|
Required Information
|
---|---|
Is equal
to or Is not equal to
|
If the data item supports displaying values, click Get Values to load
values into the Available values box. Click
![]() ![]() You can also create
your own list of values or add to a dynamically generated list. Type
each value into the Type a value to add field
and then click
![]() |
Is between
values (inclusive) or Is not between values
(inclusive)
|
If the data item supports displaying values, click Get Values to load
values into the Minimum value and Maximum
value fields. You can also type the minimum and maximum
values.
|
Contains or Does
not contain
|
This operator is not available for unformatted numeric values.
In the Value field, type the text that you want the filter to match. For example, if you type
Assist for
a filter on the job title, then the results will contain (or not contain)
values such as Concession Assistant I and Marketing
Assistant I .
|
Match pattern or Does
not match pattern
|
This operator is not available for unformatted numeric values.
In the Value field, type the text that you want the filter to match. Use an asterisk (*) to represent
multiple characters or use a question
mark (?) to represent any single character.
For example, if you type
Sales* for a filter on the job title, then the query results will match (or not match) values such as Sales Manager and Sales
Rep. I .
|
Is less
than or Is less than or equal to
|
One numeric value is
required.
|
Is greater
than or Is greater than or equal to
|
One numeric value is
required.
|
Data
Entered Before 5:00 pm
. The filter name appears
in the Apply custom filters box in the Edit
Filters dialog box.
Operator
|
Category Type
|
Required Information
|
---|---|---|
Is equal
to, Is not equal to, Is
after, Is after or equal to, Is
before, and Is before or equal to
|
Dates
|
Use the Date field
to type a date or click
![]() |
Times
|
Use the Time drop-down
lists to select an hour, a minute, and a second in 24-hour time. For
example, to specify 5 p.m., select 17, 00,
and 00.
|
|
Timestamps
|
Use the Date field
to type a date or click
![]() Use the Time drop-down
lists to select an hour, a minute, and a second in 24-hour clock time.
|
|
Is between
values (inclusive) and Is not between values
(inclusive)
|
Dates
|
Use the Minimum and Maximum drop-down
lists to specify the minimum and maximum dates. Use the Date fields
to type a minimum and maximum date or click
![]() |
Times
|
Use the Minimum and Maximum drop-down
lists to select a minimum and maximum hour, minute, and second in
24-hour clock time.
|
|
Timestamps
|
Use the Minimum and Maximum drop-down
lists to specify the minimum and maximum dates and times. Use the Date fields
to type a date or click
![]() Use the Time drop-down
lists to select the hours, minutes, and seconds in 24-hour clock time.
|