Overview
Filter Panel of the window is introduced to apply on the fly search. By using this option user can see all the applied filters, unlike existing options (advance search and search text box). This feature allows the user to add dynamic and custom filters.
Product Version and dependency
Filter Panel feature is supported by the below-mentioned modules:
...
After modules are download filter option will enable on all windows automatically, this option will display the right to search text box icon, as shown in the screenshot below.
...
Dynamic Filter
The filter panel will show the following columns as a parameter (Name, Document No and Value) left side of the window after clicking flitter icon.
...
Filter panel is showing "Document No" only, table (c_order) used in the sales order window and do not have Name and Value columns.
How to customize filter panel
In order to achieve this feature, three columns are introduced on "Column" tab of "Table and Column" window.
S. No | Field Name | Description |
1 | Selection Column | This checkbox is used to display the column in the filter panel. Users can mark more than one column as selection column. |
2 | Selection Sequence | This field is used to set order of the column to show in the filter panel. |
3 | Show Filter Option | If this checkbox is checked, then system will display top 5 values of that column in filter panel for selection. This checkbox will be displayed only if "Reference" of column is one of the following: Table, Table Direct, Search, Multi Search, and List. |
...
Users can customize the filter panel as mentioned in below steps,
...
Filter panel is showing 27 records against customer "Sky Corp", it may vary if any other filter is setup
Custom Conditions
Unlike dynamic filter, user does not need to do any setting for custom condition filter. Users can directly choose the column, operator, and value. On clicking add button data will get a filter on the window. Whatever the filter set up by the user, the same will display after the custom condition panel as shown in below screenshot.
...