Suggestion:
The System has the facility to have a conditional filter in smart filters. Which can be created, customised and used by users. They can even make the filter permanent or can delete them. There are two types of the customized filters as 1) Filter by expression and 2) Filter by column.
System has the plus sign (+) add new near the smart filter side panel header. Once the users click on the plus sign, the system allows the users to select the type of filter required.
1) Filter by expression :
1) Users have to enter filter name
2) Select the fields name from the drop down
3) Users can select the operators as required from the list (= equal to, >= greater than equal to, <= less than equal to,< less than, > greater than, != not equal to, like end with, like starts with, contains, in, between.
4) Users can give a definite value or ask a value by prompt.
5) Users can save multiple conditions using ‘and’ and ‘or’.
6) Users can select, add to permanent for permanent filter or select enable by default
7) On clicking done button the parameters are saved for user defined filter.
2) Filter by column.
1) Users have to enter filter name
2) Select the column name from the drop down
3) Users can select single and multiple selection options for column data
4) Once the users click on finish, the filter is created.
Users can clear the filter selection by clicking the option button. Same way users can remove the added smart filters by clicking on remove option.