Add a filter with the attribute operator (IN) where my list of values is stored in a field

Anonymous User — Wed, 30 Sep 2020 15:01:43 GMT

Hi All,

I've a field ${Field1} containing a comma-separated list of values.

I'm trying to figure out how to add a filter where I can check if a specified field's value ${Field2} exists in ${Field1} list. So I added a filter in my model like this :

Field1 IN ${Field2}

Field2 contains for example the value : a, b, c. and Field1 contains the value : b

Unfortunately it seems not working.

Question : Am I doing the right thing? How to do my test above in GeoEvent?

Thanks for your help.

Zakaria

Re: Add a filter with the attribute operator (IN) where my list of values is stored in a field

EricIronside — Fri, 30 Apr 2021 22:43:43 GMT

Hey @Anonymous User

The IN operator is working for me given your provided sample. In your screenshot you are showing the = (equals) operator instead of the IN operator. If you set this up to use the following, it should work.

Hiver_deneigement_zone IN ${Zones}

topic Re: Add a filter with the attribute operator (IN) where my list of values is stored in a field in ArcGIS GeoEvent Server Questions

Add a filter with the attribute operator (IN) where my list of values is stored in a field

Re: Add a filter with the attribute operator (IN) where my list of values is stored in a field