Search for a list containing ANY item of an other list

Questions
1

Hi there,
Just a quick question because I think I just found a HUGE limitation of Bubble. Am I crazy or we cannot search for a list which does not contain ANY item of an other list ?

Per example : If we have 1) many companies with many employees in each and 2) a list of people.
We cannot Search for companies which do not contain ANY people from the list 2 ?

I mean, you have first item, last item, random item, but you do not have “ANY item from this list”.

Thank you
Jo

2

You need to use an advanced filter for this… along with the :intersect with comparison…

Apply an advanced filter of This company's Employees: intersect with: list of employees: count is 0

3

I am not confortable with this feature yet, I will try, thanks !