Query on person regions

[guido_inderwiesche]

Hello,

how can I create a query on person.region as it is an array.

select re from Person re where re.regions[0] = '7E3B7AB6693647BF8A3C574B34091836' is not working

Best regards

Guido

[guido_inderwiesche · Accepted solution]

Hi Raphael, it works.

Thank you

Guido

[r_barabas]

Hi Guido

Try this:

select re from Person re where '7E3B7AB6693647BF8A3C574B34091836' in re.regions;

Note that this operator can be comparably slow when used in complex queries with a lot of data. So whenever you plan to use it, please make sure to test it on your production data.

Best regards

Raphael Barabas