topic Re: Inbox Query expression in ArcGIS Survey123 Questions

Inbox Query expression

AppDevMWCI — Fri, 19 May 2023 02:56:07 GMT

Can someone help me with this?

What I would like to do is to make the inbox only show records that match the device id of the user.

I manually assigned the device id of the user in the DeviceID field. This will serve like a unique username.

DeviceID2 retrieves the device id of the device and DeviceID3 just copies the value from DeviceID2.

For example, user with device id 'abcde123' (DeviceID2 and DeviceID3) will only see in his Inbox records with 'abcde123' in the DeviceID field.

How can I setup a query expression in my Inbox to only show records with matching values from the DeviceID and DeviceID3 fields?

Re: Inbox Query expression

ChristopherCounsell — Fri, 19 May 2023 04:22:49 GMT

I think deviceid is actually a survey123 unique id, so you may want to use pulldata("@property", 'userAgent') or something else to fill a question with a property.

https://doc.arcgis.com/en/survey123/desktop/create-surveys/prepopulateanswers.htm#ESRI_SECTION1_D52683929B1C4543B236BAC00E7F1876

To your question, I don't believe anything outside of general SQL queries (field=value) works in the inbox query expression. The username is an exception to this, and has to be called by ${username}, regardless of the survey design.

https://doc.arcgis.com/en/survey123/desktop/create-surveys/prepareforediting.htm#ESRI_SECTION1_635E85B962D64E699F1C277423026A52