Data filtering

This article shows available data filtering options, their descriptions, and usage.

Filters support expressions in all available column types.

Filtering options

• search: type a search term to see all values containing 

• true/false: type true or false to see the values containing

• expressions: >/</=/range

Filters usage 

• String: if value contains search term ignoring case

• Number: =, >, <, range

• Integer: =, >, <, range

• Date: =, >, <, range(must match date format)

• DateTime: =, >, <, range(must match date format)

• Time: =, >, <, range(must match exact time format)

• List: if value contains search term ignoring case

• Checkbox: true or false

• Userlist: by typing part of username ignoring case

Expression examples

>a, <b, =n, where a,b,n are column vales 

true/false  - shows checked/unchecked rows 

Open