Search Constrain list with each item list

[lukman]

Hi, i have “Property” data, which has list of “Marketing”

and a “User” data has list of “Marketing” too.

How do i search for “Property” who has 1 or 2 of “Marketing” from the User’s Marketing data?

If i have
Property 1 with Marketing A
Property 2 with Marketing A and B
Property 3 with Marketing B

and
a User with Marketing A and B

i want the result will be Property 1, 2, and 3

If i use contains in the Do Search, it’s give me error.

But using Advance in the :filter only give me Property who has exact same of the User’s Marketing (only give me Property 2)

[bestbubbledev]

In the :filtered section it should have operator called intersects with.

[lukman]

Thanks, it’s worked