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.
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).
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" |
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
With the filter expressions = null or! = Null can be checked on empty.
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