Datagrid search with dropdown and multi selection

Hi guru's,   In our app, we have implemented a DataGrid with search fields. Some of these fields are set as a dropdown with multi selection switched on. Now when we select multiple entries in the dropdown, these entries are used in the selection as ‘OR’. As an example, we have a grid which shows Employees and the grid has a filter on Skills, so if we would select skill “Mendix” and skill “Scrum”, then the result will be: Employees that have either one of the skills or both skills.   The question now is, is it possible to treat the selected options as AND instead of OR. So we only want to see Employees that have both Skills assigned in this case.   Looking forward to your thoughts and hopefully solutions!   Thanks,   Jos
1 answers

Hi Jos,

You can try using listview instead of datagrid and use dropdown filter widget but I doubt you will be able to achieve what you want. Or try Grid Search widget from appstore if this helps (I personally didn't use it so cant tell much).

Other option to achieve what you want is to implement custom search instead of out of the box. You might need a helper search entity associated to your main entity and have all you search filters in the helper entity (either as attributes or associations from helper entity). On ‘search button’ you can call a microflow where you can use retrieve action to filter however you want and than associate the results list to be shown on the page. (note: if there are large number of results e.g. >2000 or >5,000 or you are doing complex retrieve and looping then you might have to think about performance)

There is a forum post on custom search if that helps you.


Hope this helps!