Filter examples:

Filter examples and examples of the use of tags/variables in filters.

Contents

General

Field	Filter value	Comment
Search name	= Philips	Contacts with a name that is identical to Philips.
Search name	< Philips	Contacts with a name that is ‘less’ than ‘Philips’: from ‘AAAA’ to ‘Philips’.
Search name	> Philips	Contacts with a name that is 'greater' than ‘Philips’: from ‘Philips’ to ‘ZZZZ’.
Search name	!*Philips	Contacts with a name that is not equal to ‘Philips’.
Search name	>= Philips	Contacts with a name that is ‘greater’ than or equal to ‘Philips’: from ‘Philips’ to ‘ZZZZ’, inclusive.
Search name	<= Philips	Contacts with a name that is ‘less’ than or equal to ‘Philips’: from ‘AAAA' to ‘Philips’, inclusive.
City	*berg	Contacts whose city name contains the letters ‘berg’. For example, ‘Beekbergen’ as well as ‘Bergen aan Zee’.
City	@new	Contacts whose city name starts with ‘new’ , such as New York and New Orleans.
Postal code	[]	Contacts for which the postal code field is empty.
Postal code	![]	Contacts for which the postal code field has a value.
Customer since (custom field)	> 01/01/1955	Contacts who have become a customer after January 1, 1955.
Customer since (custom field)	<= 01/01/2000	Contacts who have become a customer before January 2, 1955.
Customer since	>= 01/01/2000 <= 31/12/2000	Contacts who have become a customer in 2000.

Filter by date and time

You should distinguish between filtering by dates, filtering by date/time and filtering by time.

Examples of filters on date fields

When a filter field above a date column gets the focus, a search button appears that allows you to open the date control. The date control is only enabled if the filter field is empty and if the field contains one date. You cannot use the date control for MultiSelect.

Filter	Comment
10-12-2007	On 10/12/2007.
1-12-2007..31-12-2007	From 1/12/2007 through 31/12/2007.
1-12-2007..	From 1/12/07.
..15-12-2007	Through 15/12/2007.
1-12-2007;8-12-2007;15-12-2007	December 1, 8 and 15 of 2007.
1-12-2007..15-12-2007;31-12-2007	December 1 through 15 and December 31 of 2007.
2007	Everything in the year 2007.
12-2007	Everything in December of 2007.

Examples of filters on date/time fields

In date/time fields, the date and time can be entered or only the date. The options for date fields also apply to date/time fields, but you can also filter by time.

Filter	Comment
10-12-2007 15	On 10/12/2007, from 3:00 PM to 4:00 PM.
1-12-2007 08:00..2-12-2007 17	From 8 AM on 1/12/2007 through 5 PM on 2/12/2007.
1-12-2007..	From midnight on 1/12/2007.
..15-12-2007 15	Through 3:59 PM on 15/12/2007.
1-12-2007;8-12-2007;15-12-2007	December 1, 8 and 15 of 2007.
1-12-2007..15-12-2007;31-12-2007	December 1 through 15 and December 31 of 2007.
2007	Everything in the year 2007.
12-2007	Everything in December 2007 (unless the date format is MM-DD-YYYY).

Examples of filters on time fields

Filter	Comment
11:30	11:30 AM only.
11	From 11 AM through 11:59 AM.
11:30..12:30	From 11:30 AM through 12:30 PM.
11..12	From 11:00 AM through 12:59 PM.
[today]..[tomorrow]	Everything for today
[today -7]..[tomorrow]	Everything for the past week through today

Filter by numerical values

The following operators are available in numerical fields:

; : (multiple values).
..: (through value).
!: (not this value).

Some examples of filters on numerical fields:

Filter	Comment
1000	Only the value 1000.
1000..	From 1000.
1000..1999	From 1000 through 1999.
1000..1999;4000..4999	From 1000 through 1999 and from 4000 through 4999.
1000;2000;4000;5000	All values containing 1000 or 2000 or 4000 or 5000.
..1000	Through 1000.
50.00	The use of periods and commas in numbers matches the way the data is displayed in the view.
12.36	12.36.
12.35..13.45	12.35 through 13.45.
.45....6	0.45 through 0.6 (0.61 does not meet the filter criterion).
1	1 (1.000 is also found).
!4..7	Not 4 through 7.000.

Filter by check boxes

In Y/N fields (check boxes), only the values Y, N or nothing can be entered.

Filter	Comment
Y	Only selected check boxes.
N	Only deselected check boxes.
	Both Y and N.

Directly to