Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

As far as you know, in 1.2.0 release Filtering was added. Now you can easily filter data in the table. 

This article shows available filtering options , and their descriptions , and usagefor user to search for a value in grid, with our latest release 1.19.0.

Filters

...

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 

...

options and usage 

  • With String, Number, Integer, Date, DateTime, Time, List, Userlist, List column types: Table Grid only support search by text value. For Date, DateTime, Time column types, please make sure that the search value match with the exact custom format that user had set in the Column Configuration.

For more information, please read via: Column Types

  • With Checkbox column type: user can search by True - Checked box value and False - Uncheck box value.

Expression examples

Navigate to an issue in a select project, you will see (blue star) button to filter value in the grid.

...

User can search for the value in the search box like the example below:

...

With Checkbox column type, user can search for True/False like the example below:

...

 

...