I have a repeating group that shows different freelancers for a client.
I want to show only the freelancers that in their category (list of texts, exist as options set) have one (or more) of the categories the customer has defined he’s looking for in his profile (same list of texts/options set).
I thought a simple:
Freelancer_Category contains Current User’s Customer_profile’s Customer_Freelancer_Category
will do the trick, but it remains red, and doesn’t allow to save it.
I didn’t find an answer on the forum, only for search all list in another list.
Hi there, @shmilovich.elad… if I understand your post correctly, I do the exact same thing in one of my apps by using an advanced filter. I believe your advanced filter would need to be something like…
Advanced: This Freelancer's Freelancer_Category contains list Current User's Customer_Profile's Customer_Freelancer_Category
The part of the filter after contains list is hard to define without knowing exactly how you have things set up, but again, I think something like what I wrote above could get you down a good path. Hope this helps.
Hey, @shmilovich.elad… you can use an advanced filter in a repeating group. After Search for Freelancers in your data source, click More and select the :filtered option. Then, when adding a constraint on the filter, scroll all the way to the bottom of the dropdown and select the Advanced… option.
For anyone who might come across this thread down the line, privacy rules strike again! If you think you have a search set up properly and you aren’t seeing the data you are expecting to see, it never hurts to check your privacy rules to make sure they aren’t tripping things up.
And for anyone who might come across this thread - @mikeloc spent over an hour to review my app and find the reason. @Bubble - you should be thankful for having him as a member of this community.
