/
Data filtering

Data filtering

By svitlana (Deactivated)
Oct 10, 2018
1 min



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 

 

Related content