Versions Compared

Key

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

Filtering was added in 1.2.0 release . Now you can easily filter data in the table. 

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

Excerpt
hiddentrue

You can filter data within the grid using available filtering options.

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 

less thanImage RemovedImage RemovedImage RemovedImage RemovedImage Removedfor user to search for a value in grid, with our latest release 1.19.0.

Filters 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:

...

 

...