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?