## Views: Filtering Values

One of the basic functions of Ninox is the ability to filter data in a view, this means to display only certain data. The Basics of working with different views is discussed in the previous chapter. At this point, the filter options will be explained in more detail.

Simple Filter

Place a filter by clicking on the column head.

In the field “Filter” you can enter any search text. Ninox then displays only those records that contain this text in the appropriate column. Uppercase and lowercase is ignored.

Of course filters can be placed on multiple columns. In order for a record to be displayed, it must meet all the filtering criteria (logical AND).

Filter Expressions

Ninox also supports more complex filter conditions in the Filter field above.

 =”Value” Exact comparison with a string like “Value” Checks whether “value” is ignoring uppercase and lowercase letters =1234 Exact comparison with a number >100 Greater than 100 100 >=100 Greater than or equal 100 <100 Less than 100 <=100 Less than or equal 100 !=100 Inequality 100

These terms may also be combined. Ninox supports three logical operators AND, OR, and NOT. Some examples:

 >10 and <100 Between 10 and 100 (exclusive) >=10 and <=100 Between 10 and 100 (inclusive) not like “done” only rows that contain “done” like "done" or like "reset" Only rows that include "done" or "reset"

Date Filter

For columns with dates Ninox supports the entry of a complete or even partial date in the filter:

 03/25/2015 Only the 03/25/2015 03/2015 All data in March 2015 2015 All data in 2015

Comparative filter supports Ninox at this point not yet, a small detour but this is also possible: “Show Columns …” column with the function from the View menu. Insert the formula

format(date, "YYYY-MM-DD")

Then you can compare how

>="2016-02-01" and <="2016-02-29

to work

See empty values

With the filter expressions = null or! = Null can be checked on empty.