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.
Exact comparison with a string
like “Value”
Checks whether “value” is ignoring uppercase
and lowercase letters
Exact comparison with a number
Greater than 100 100
Greater than or equal 100
Less than 100
Less than or equal 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:
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.

Advanced filtering options

In some cases, filters can not be implemented through the mechanisms described above. For example, if you want to combine data from multiple fields to a combined criterion. But these cases can be covered with Ninox. The trick is to define the filter over an additional calculated column.
Use the function “Show Columns …” from the View menu and drag a formula in the list of visible columns. In this formula, you can access all the fields of the table, also from the fields of linked tables. Ideally, you build the formula so that it returns a Yes / No value. Then you can create a filter for this calculated column to “Yes” or “No”.
If you want, for example, show all rows that have a date in the future, you can do this on a computed column: Define a column with the function:
Date> Today
and date> Today () with textual input of Fomel.
Set the filter for this column to “Yes”.
Last modified 1yr ago