Query the Inbox in Survey123

1221
1
06-08-2020 08:16 AM
BrianBerdel
New Contributor III

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?  

0 Kudos
1 Reply
JamesTedrick
Esri Esteemed Contributor

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}

0 Kudos