Sorting a repeating group with checkbox

[swanin.business]

Hi Guys !

My customer is asking me to sort a repeating group with on or several checkboxes, instead of doing a dropdown I have made a focus group with a repeating group inside that has a checkbox which is dynamically setted.

What I want is to sort a repeating group according, to this focus group and the checkboxes selected.
Hereunder is a video that explains the problem more accurately.

Thank you for your help

[kibermaks]

Hi,
Well, you are trying to do a filter, not a sort.
I’ve done this in one of my projects - it was a tough job. However, I had it as single-select dropdowns (meaning selecting, e.g. one country, one Project Type and so on). Here, as I understand it, you want to find the intersection of two lists: a list of departments and a list of checks. It’s the next level, and I believe it will be incredibly slow.

If you can lower business expectations and replace them with a single selection, I might suggest how to do this.

[kibermaks]

If LIST x LIST is crucial, you can do a dynamic filter for your data.
Unfortunately, “Do a search for” doesn’t support this operator, so it couldn’t be done on the server, but only on a client with a …:filtered operator

Do a search for Partners(do all possible filtering here to reduce data going
to client, e.g. if you have other filters like Status, Type, etc.)
→
:filtered. Here in List Filter settings add …advanced filter item(show below)
with smth like:

[pseudocode]
This partner's Departments'ID intersect with Checked Departments'ID:first item is not empty

If this is false - it means that no match between Departments and Checked State exists and therefore this item will not ‘survive’ this filter.

P.S. And don’t forget to check the “Ignore empty constraints” setting above(so when no checkboxes are checked, this Advanced filter won’t be applied at all)