Filter criteria

Filter criteria provide you with options for numerous smart searches.

Contents

General comment

Using filter criteria provides you with numerous extra options.

Apply filter criteria:

Overview

Use these options to use the filter efficiently.

Filter

Meaning

Example

value

Quick filter. Value is present.

=value

Exact value

!value

Value is not present

The search results will never contain empty cells.

 

value1;value2

Quick filter on multiple values (OR filter)

=value1;=value2

Exact value (OR filter)

#value1;value2

Quick filter on multiple values (AND filter)

value..

From

..value

to

value1..value2

between

?

wildcard: random character

 

[]

field is blank

![]

field is not blank

@value

starts with...

 

Search for @ using the wildcard *

!@value

does not start with...

 

&value

ends with....

!&value

does not end with

 

<value

is smaller than

>value

is greater than

>=value

is greater than or equal to

 

<=value

is smaller than or equal to

 

Y/N field (in a view usually represented by a check box)

  • y returns all records in which the check box is selected
  • n returns all records in which the check box is deselected

Extra options for date fields

When you filter on date fields, there are a number of smart options you can use. You do not always have to enter the complete date, depending on the situation. If you enter a part of the date, Profit will complete the date based on the below rules.

Option

Explanation

9

From Jan 1 2009 through 31-12-2009 (09 or 2009 gives the same results)

8..9

From Jan 1 2008 through 31-12-2009

10-9

From Oct 1 through Oct 31 (can also be specified as 10-2009)

1-1-..9

From Jan 1 of the current year through 31-12-2009

--;--2009

Current date or the current date in 2009

1--..10--;20--..30--

From the current year and month, the days 1 through 10 and 20 through 30

--;-1-;-12-

Current date or the same day in January of the current year or the same day in December of the current year.

1-1-..31-15-

From Jan 1 of the current year through March 31 of the next year.

--

Today

!--

Not today

--;[]

Today or empty

a..F10 (function key)

Search through value (only if MultiSelect is not used)

1--

first day of the current month/year

1-1-

January 1 of the current year

2009

f-to: Jan 1 through Dec 31 2009

--2007

Current day/month. but in the year 2007

012009..032009

Returns the first quarter of 2009:

-01-..-03-

The first quarter of the current year. This will still work the next year, so you will not have to adjust the filter.

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