Multi Value Combobox Filter
Last updated
Last updated
The multi value combobox filter is a control available in the filter and editable panels. This control can filter the associated grid for one column with multiple values.
If the control is used within a filter panel the grid it refers is the same as specified for the panel.
In an editable panel you can apply the filter manually, through a javascript action, where you can get and use the data selected in the control.
You can configure the control in the Input Controls folder, where you have to choose the type "Dynamic Combobox" and associate a selector; the selector must be a dynamic selector having the Multi Value checkbox selected (see image below).
When the user types into the multi-value combobox, the typed value is validated and only matching values are shown.
You can select an item and the control shows the relative chip. After that, you can type again another text and validation is performed again, in order to add additional items.
You can remove a chip by clicking on the X within it or remove all chips by clicking on the X on the right of the combobox.
When you click on the search button, an IN type filter condition is applied to the grid with the selected values.
There are optional settings available for this control, accessible using the "Additional config." property for it:
Important note: it is a good practice to limit the amount of chips to include in this control (through the "maxValues" additional property), in order to limit how many codes to pass forward to the IN operator on the SQL query executed on the server side: the more are the values in the IN clause and more complex will be the query for the database. It is not a good idea to have a large amount of values in the IN clause, otherwise the database will be negatively affected by the query, especially in a multi-user application.
