Inbox query syntax with username variable

AndrewMoskaLee

Was there a change made that affected the use of ${username} in the inbox query statement?  I am exactly copying the syntax as it is displayed on the Survey123 help page:

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

The only difference is that instead of "creator", I am using 'crew_usernames' which is one of my fields.  So its actually:

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

If I input my actual username instead of ${username} the expression works as expected.  So that looks like:

crew_usernames LIKE '%Andrew.MoskaLee@dec.ny.gov_nysdec%'

So there is definitely a problem with the syntax surrounding the username variable.  Does anyone know the correct syntax?  Or have any other ideas?

Thanks,

-Andy

JamesTedrick

Hi Christopher,

The main issue is the use of '+' for string concatenation - that is not allowed in standardized sql feature services.  Per Standardized SQL functions in ArcGIS Online—ArcGIS Online Help | Documentation , one of the following options can be used:

- CONCAT - when you want to join strings to gether

- POSITION - when you want to determine if a string occurs in a field.  This is the one you likely want for your scenario (given a field of the name user list, I am guessing it contains 0+ usernames a record could be assigned to).