I have a repeating group.(Data type is users) Every user has a list of role levels. [image] (role levels is an option set) [image] (This is what I want) Current user can select role levels in the app. [image] When the current user selects role levels, it is stored in a custom state.(it’s al…

You should use an advanced filter by comparing this user’s role levels count to the (custom state) selected role levels count and get the ones that have the same count as selected role levels count. Comparing means intersecting. It should be something like this: This User’s role_levels_candidate in…

No, I mean, I want to show all the users that have at least one of the selected roles. If role Junior and role Senior are selected, I want to show all the users that have role junior and role Senior. It doesn’t matter if the users have both roles or only one.

Then it should be This User’s role_levels_candidate intersect with (Wherever the custom state is)'s selected_role_levels : count > 0

Thanks. It works but at least one of the roles should be selected to show results… It’s okay!

You can try this method to show results when none are selected. [image] Matching 2 lists while ignoring constraints (:filter) Tips Having issues with :filters giving empty results (eg. no results in your RG)? Here are 2 ways to go about solving this issue! Note, things i…

How to filter a list of users in a repeating group by a list of data?

Need help

ihsanzainal84 January 8, 2024, 7:23am 6

You can try this method to show results when none are selected.

Topic		Replies	Views
Filtering a repeating group by checking if a group from the repeating group has at least 1 element from the filter list Need help	19	495	May 21, 2024
How to filter repeating group based on custom state list Database	1	335	January 28, 2023
List Filter Advanced Need help	5	1504	February 22, 2022
Filtering list of tag using another list Questions	8	1038	December 6, 2022
How to filter a list held in custom state for a repeating group App Organization	6	445	May 15, 2023

How to filter a list of users in a repeating group by a list of data?

Related topics