Support filtering multi columns, currently the inline filter only works for each single column by matching the input text like SQL where condition with wildcard, in other word, after filtered on one column, then input filter condition in another column, the previous filtering condition is ignored! it is desired to filter the grid by all active filtering conditions in all columns
Support filtering multi values with delimiter(;) using OR logic, e.g input text "ipad ; ipod" can filter out records with column content contains ipad or ipod.
Support filtering number and date field by range using the operator > and <, e.g input text > 400 can filter out records with number content greater than 400.
Turn the current pure input text field into awesome field with distinct values of the current column as drop down list, allow user to multi select the value, just like how Excel does filtering
Support clearing all active filtering conditions by one click. e.g clearing filters
Support saving the filtering conditions as saved version, can be set as default when next time open the same datatable, also can be selected re-used next time by other user if publicly shared
Support filtering multi columns, currently the inline filter only works for each single column by matching the input text like SQL where condition with wildcard, in other word, after filtered on one column, then input filter condition in another column, the previous filtering condition is ignored! it is desired to filter the grid by all active filtering conditions in all columns
Support filtering multi values with delimiter(;) using OR logic, e.g input text "ipad ; ipod" can filter out records with column content contains ipad or ipod.
Support filtering number and date field by range using the operator > and <, e.g input text > 400 can filter out records with number content greater than 400.
Turn the current pure input text field into awesome field with distinct values of the current column as drop down list, allow user to multi select the value, just like how Excel does filtering
Support clearing all active filtering conditions by one click. e.g clearing filters
Support saving the filtering conditions as saved version, can be set as default when next time open the same datatable, also can be selected re-used next time by other user if publicly shared