Please help, I am trying do a filtered search as follow:
I have a datatype call Relationship which contain a list of another datatype call brokers.
I want the ability to filter the list of relationship that contain any brokers that is in a list of brokers that the user will select.
The advance filter contain list doesn’t work correctly because if you have two brokers in a list it will only shows relationships that contain exactly the two brokers. Which is not what I want, it should show any relationships that contain any of the two brokers.
Anyone know how I can implement this without resorting to recursively searching for relationships for each brokers and intersecting it?
could you use the advanced filter with the operator ‘intersects with’ and the count be 1 so that only at least one of the brokers in the selected brokers list is in the data field list of brokers of a Relationship?
Unfortunately that doesn’t work either. Surely there’s a way to filter more efficiently with bubble.
The only way I could think of to make this work is to store relationships in the the broker data field too. then do an intersect between the two lists, but that’s not very efficient.