Page tree
Skip to end of metadata
Go to start of metadata

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 

 

  • No labels