thumb_up
thumb_down
link
Copy link
Copied
insert_emoticon
lmatfy
Copied

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

  1. Filter data
  2. Quick filter
  3. Simple filter
  4. Advanced filter
  5. Compare columns using a filter
  6. Filter management
  7. Filter variables
  8. Filter criteria
  9. Examples

Process

View data

Work area

profit