Filter array

Lars Hofstetter

Hello,

I'm making a query of an array of locations. I then want to get back all the records that have one of these locations. Right now I have a setup using contains but this does not work. It always checks if the whole array is contained in the record. 

Each record always has only one location and not multiples. 

How can I set this up? I was wondering maybe I should need the in operator instead of the contains operator, but I had an error on that.

There are screenshots below for better understanding.

Thank you for the help,
Lars
[Bildschirmfoto 2022-01-23 um 09.08.25.png][Bildschirmfoto 2022-01-23 um 09.08.35.png][Bildschirmfoto 2022-01-23 um 09.11.15.png]

Lars Hofstetter

Can someone help me here?