I am struggling to combine 2 different data types, “User” and “Batch”, in the same repeating group.
“User” has some fields in the database and the one I want to use is “interest” - a list of things.
“Batch” has some fields in the database and the one I want to use is “category” - a list of things.
The “user” has some interest lists they liked on the platform.
“Batch” has some categories similar to the interest list.
What I want to do is I want to show only those batches in the repeating group in which “batch” (categories list ) and “user” (interest list ) will be matched. Both have the same data from the option set.
Hi there, @mannanbutt678… if I understand your post correctly, one of the following advanced filters should do the trick (I only showed both in the same screenshot to make it easier for me).
The first filter would be used if the batch’s list of categories must contain all of the interests in the current user’s list of interests. The second filter would be used if the batch’s list of categories needs to contain at least one of the interests in the current user’s list of interests.
If you have never used an advanced filter before, note that the filtering takes place on the client (browser) side. So, if you don’t have any constraints on the search for batches, that search is going to return all of the batches in the database to the client, and then the filter will be applied. Just something to be aware of and keep in mind from a performance perspective.
Thank you so much for your help! I really appreciate it.
Yes, I have a one-constraint on the search for batches as well.
I have used the second filter that would be used if the batch’s list of categories needs to contain at least one of the interests in the current user’s list of interests and it works perfectly!
