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.

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”.