topic Search() Appearance wrong integer filter in ArcGIS Survey123 Questions

Search() Appearance wrong integer filter

OfraAi — Fri, 28 Jun 2024 20:13:51 GMT

I have a survey created using Survey123 connect on ArcGIS Online.

I select city from list in the 'choices' tab, and have to select station, from feature service table, filtered by that city.

The ${CityName} column has a domain value, that is Integer and label as string.

I use autocomplete search:

autocomplete search("STList?url=https://utility.arcgis.com/usrsvcs/servers/xyz/rest/services/Servicename/MapServer/1","matches", "CityCode",${CityName})

I've created the survey a long time a ago and it worked perfect! Few months ago it stopped filtering the list.

When I check the survey in browser and F12, I see that the rest query created contains:

(name IS NOT NULL) AND CityCode = '182'

The column is integer and the filter value is string, so the query fails!

In XLSX the CityName is defined as esriFieldTypeInteger, so does the column CityName in the survey feature service, and in the table feature service for the list.

What causes the survey to create string value, how can I change it.

Thanks for any help

Ofra A

Re: Search() Appearance wrong integer filter

IsmaelChivite — Mon, 09 Oct 2023 15:14:47 GMT

@ZhifangWang @ZacharySutherby

Re: Search() Appearance wrong integer filter

OfraAi — Mon, 16 Oct 2023 13:33:18 GMT

Do you have any idea, and can help me?

@ZhifangWang @ZacharySutherby

Re: Search() Appearance wrong integer filter

ZacharySutherby — Tue, 17 Oct 2023 23:53:44 GMT

Hello @OfraAi,

Apologies for the delay, I've created internal issues for not sending the integer value as a string. It looks like this issue only impacts map services and does not impact feature services. As a workaround enabling feature access (read-only is fine) on the service will resolve the issue.

Re: Search() Appearance wrong integer filter

OfraAi — Fri, 28 Jun 2024 20:14:11 GMT

Hello Zach,

The survey service is based on feature layer, in order to collect data.

The dynamic data layer is access as feature access, with /1 at the end:

url=https://utility.arcgis.com/usrsvcs/servers/xyz/rest/services/Servicename/MapServer/1 ","matches", "CityCode",${CityName})

I did not understand what you mean

Regards

Ofra