topic Re: query allowUpdates not working in ArcGIS Survey123 Questions

query allowUpdates not working

OussamaMerhi — Wed, 09 Jan 2019 10:30:16 GMT

Hi,

query allowUpdates is not working now. It was working before and suddenly stopped working. I am using Survey 123 Version 3.1.158

Any suggestion. Find attached my excel sheet

Best,

Oussama

Re: query allowUpdates not working

JamesTedrick — Wed, 09 Jan 2019 22:47:22 GMT

Hi Oussama,

By 'suddenly stopped working', was there no change in app version (i.e., going from 3.0 to 3.1)? Also, have there been any changes to the feature service properties?

Re: query allowUpdates not working

OussamaMerhi — Thu, 10 Jan 2019 07:08:52 GMT

Dear james,

yes i think we were using 3.1.149 and moved to 3.1.158.

how can we solve it.

best,

oussama

Sent from my Samsung Galaxy smartphone.

Re: query allowUpdates not working

Anonymous User — Thu, 10 Jan 2019 11:02:28 GMT

Hi Oussama,

The documentation for editing repeats via the Inbox can be found here: Prepare for editing existing survey data—Survey123 for ArcGIS | ArcGIS . The correct syntax to query repeat records and allow updates is:

query allowUpdates=true

I took a look at your xlsx file and it is missing the =true after allowUpdates, and as the default is false, updates will not be allowed. Is this the problem you are encountering or are you not seeing any repeat records in the survey?

Please try updating this syntax and hopefully you can edit and update repeat records in your survey.

Regards,

Phil.

Re: query allowUpdates not working

DelaereMickael — Thu, 04 Apr 2019 13:10:40 GMT

Hello i have tried this request :

allowUpdates=true query="bac_statut<>'retrait'"

is the != <> operator supported?

which are the supported operators in the query parameter?

notice that it works in the query windows of the rest service.

the request look like this in the xml of the redownload form

<bind esri:parameters="allowUpdates=true query="bac_statut<>'retrait'"" nodeset="/DMA_PAV/GRP_BAC/REP_PAC"/>

Re: query allowUpdates not working

JamesTedrick — Fri, 05 Apr 2019 18:27:48 GMT

Hi Delaere,

Have you tried the query at the feature service's query operation in the REST API and confirm it works there? I would expect the substitution of characters with &XX; that you see - those are standard XML escape characters.

James

Re: query allowUpdates not working

DelaereMickael — Mon, 08 Apr 2019 07:14:56 GMT

Hi james,

yes i tried this in the where clause

and i get the good result

I use the double quotes after the query parameter.

Re: query allowUpdates not working

JamesTedrick — Tue, 09 Apr 2019 23:10:35 GMT

Hi Delaere,

Can I ask that you try the query at the parent layer's 'Query Related records' entry? I'm finding that if the query field is NULL, the feature is omitted from the query. For example, this screenshot should have returned 16 records, but 14 of them have null for the field weather:

Re: query allowUpdates not working

DelaereMickael — Tue, 16 Apr 2019 13:29:57 GMT

Hi James,

thanks for answer,

i tried the folowing syntax : allowUpdates=true query="bac_statut in ('projet','déployé')"

and it works fine.

Re: query allowUpdates not working

CarissaPhantom — Fri, 01 Oct 2021 19:53:49 GMT

This is working for me: query allowUpdates=false

Now I need to retrieve the last survey taken, and the userID in ${AssignedInspector3}

Is there a clean way to do this?

Re: query allowUpdates not working

CarissaPhantom — Wed, 23 Nov 2022 20:09:37 GMT

@MichelleWilliamsERM