frappe / frappe/datatable

Inline filter improvement ideas

Open
#43 0 comments 2 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
1.3k
Forks
216
PR merge metrics
No merged PRs in 30d

Description

1. 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

2. 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.

3. 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.

4. 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
![image](https://user-images.githubusercontent.com/12823863/45670706-0e855200-bb56-11e8-8e3b-29c14ca28913.png)

5. Support clearing all active filtering conditions by one click. e.g clearing filters

6. 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

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.