Below are the features offered by our custom Multi-Select Dropdown control:
We can search the item within the data source without worrying about data source size in the database like we can search within millions of records but it will return the list of the top 50 only along with the selected records.
We can select the records inside the dropdown via a checkbox and after saving, all the selected records will be moved to the top.
We are displaying the selected count as well on the top only when the selected count is greater than 0.
We can use this control with Aggregate as well as Advance SQL. Inside Rumpke Style Guide you will find the example for both aggregate and Advance SQL.
We can use this example even without creating any new table to store the filtered list, we have added the example to work with the localist variable as well. This control support millions of record data while searching and selecting but you have to define the limit of max record in your query whether it's aggregate or advance SQL and define the same max record property on your list widget. When you search this control will search in your DB and bring the matching result, when you select the list item it will sort/move the selected item on the top always so that it will become easier for the end-user to remember what the have selected.
In new example has been added in which we are not using any table to store the filtered list, now we are saving records in the localist variable.
We have introduced a dropdown control that can have search capabilities and multi-selection with checkbox but at the same time like select2, it won’t add the selected items on the top which causes the distortion of UI. We have tested this component with 1 million records and we didn't face any performance issue. Also, this control shows the selected count on the top.
We can use this control with Aggregate as well as Advance SQL. You will find the example for both aggregate and Advance SQL.