Search
K

# Filtering values in views

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 you can set a from and a to date.
You can also search for "empty" or "not empty" fields.
If you want to filter, group or sort by month and year you can insert a calculated column with the formula:
`yearmonth(Date) `
To filter for a October 2019 you can type into the filter line of the column e.g.: 2019/10
or if you want to filter for a certain month and the empty entries please type:
= "2019/09" or = null

### See empty values

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