Query the Inbox in Survey123

BrianBerdel — Mon, 08 Jun 2020 15:16:45 GMT

It seems there's been an update to ArcGIS Online security settings as of June 2020 that removes the ability to disable Standard Query support. This in effect renders the ability to use the ${username} function in the inbox query useless since it requires it. We're trying to query the inbox with something like this:

${username} LIKE '%' + assignee + '%'

This is a previous thread that lays it out nicely...

https://community.esri.com/message/933252-re-querying-inbox?commentID=933252#comment-933252

More guidance on how to use the {username} operator, this is the link that shows in Survey123 Connect where the inbox configurations are...

Prepare for editing existing survey data—Survey123 for ArcGIS | Documentation

...and the notice of removing the setting that removes the setting to disable standard query functionality.

FAQ: What are the implications of the June 2020 ArcGIS Online Standardized SQL Query Enforcement?

We have an application that uses Field Licenses that rely on our ability to query the inbox in Survey123 so each license only sees features assigned to them so without the ability to query the username those field licenses are of no use. Is there a way to use the ${username} operator in a query with standard query support enabled?

Re: Query the Inbox in Survey123

JamesTedrick — Wed, 05 Aug 2020 22:39:44 GMT

Hi Brian,

Yes, Standardized SQL has been enforced for all ArcGIS Online organizations. The Survey123 documentation will be updated to reflect that. In your situation, it appears you shouldn't be using a LIKE (wildcard match) statement. Assuming the field is named 'assignment', the statement should be

assignment = ${username}

topic Query the Inbox in Survey123 in ArcGIS Survey123 Questions

Query the Inbox in Survey123

Re: Query the Inbox in Survey123