nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need help query records to inbox

JeremieCote

Hello,

I need help building a working QUERY expression to query specific records in the Inbox.

I want users to have access to records they created and to records in which their username where selected from a select_multiple question.

So the logic of the second part of the query is that the select_multiple question is called AllowedUsersInbox and it has my users usernames as choices. If the currently logged in user in S123 was selected in the select_multiple question of a record, he will have access to that record to edit via the inbox.

With the query in the screenshot I get an error message:

How can I make the query works?

Thanks a lot,

Jérémie

Find more posts tagged with

Accepted answers

JeremieCote

I managed to make my query works by reading this post:

https://community.esri.com/t5/arcgis-survey123-questions/inbox-query-expressions-with-multiple-select/m-p/774048

I took screenshots of my query and xlsforms if you want to see the results:

All comments

JeremieCote

I managed to make my query works by reading this post:

https://community.esri.com/t5/arcgis-survey123-questions/inbox-query-expressions-with-multiple-select/m-p/774048

I took screenshots of my query and xlsforms if you want to see the results:

JeremieCote

Hi!

Thank you I forgot the brackets!

The query now works when I select a single user but doesn't if I select more than one.

The output of my select_multiple question looks like this: John.Smith,Bob.Obama,William.Kurst

I think the usernames sould be separated by a space and put between '' for my query to works.

Is this right?

If yes, is there a function to do that or should I built a custum javascript function?

Thanks again!

DeonLengton

Hi Jérémie

Try Creator=${username} or ${username} IN (AllowedUsersInbox)

The syntax of the IN clause requires a pair of brackets.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.