topic Re: Inbox query filter by username in ArcGIS Survey123 Questions

Inbox query filter by username

AntónioMartins — Thu, 13 Apr 2017 11:00:15 GMT

Hi there,

I'm trying to find if it's possible to filter the inbox data by the username of the user accessing the survey data or if there is a workflow to support this need.

Thanks

António Martins

Re: Inbox query filter by username

JamesTedrick — Thu, 13 Apr 2017 17:26:25 GMT

Hi António,

We won't support filtering the Inbox by username when version 2.0 (which introduces the Inbox) is released; we do have it as an enhancement for editing support that we want to address relatively quickly.

Re: Inbox query filter by username

Anonymous User — Sat, 13 May 2017 18:25:31 GMT

Are there plans to add in the ability to allow a user to select part of the filter that is being applied for the inbox query?

Meaning, that the survey form has a field/question that contains a "Project Number" that is populated during the survey. The idea is that the user could enter a "Project Number" before refreshing the "Inbox" and then only have the surveys that are related to the user entered project number be returned to the inbox.

Something even more advanced would be to allow for the utilization of a field within the form to provide choices for the filter; which would be similar to the table filter that could be applied within the Web Map Viewer table.

Re: Inbox query filter by username

AntónioMartins — Mon, 15 May 2017 18:06:06 GMT

Thanks for your reply.

Best regards,

António Martins

Re: Inbox query filter by username

JamesTedrick — Mon, 15 May 2017 18:27:05 GMT

Hi Mike,

While not directly how you are describing, we are planning for some ways to have a more dynamic where statement at the user level to accomplish what I think you are wanting. One of the approaches we are considering would involve making a URL parameter to set the query- this might accomplish the filtering on project you describe.

Re: Inbox query filter by username

deleted-user-qzyyiYme1rz9 — Wed, 29 Nov 2017 18:42:02 GMT

James, its been a few months and I now have version 2.5.44. I was wondering if filtering the inbox by username is available yet or if there is a date for when it will be available?

Re: Inbox query filter by username

JamesTedrick — Wed, 29 Nov 2017 21:25:51 GMT

Hi Alexis,

This was introduced in version 2.1 - see https://community.esri.com/groups/survey123/blog/2017/06/02/world-milk-day-release-21 for details. We do appear to have missed placing it in the documentation; we'll update it to reflect the variables that are supported.

Re: Inbox query filter by username

deleted-user-qzyyiYme1rz9 — Wed, 29 Nov 2017 21:45:34 GMT

Perfect, thanks!

Re: Inbox query filter by username

deleted-user-qzyyiYme1rz9 — Wed, 29 Nov 2017 22:13:46 GMT

Ok one more question now, how do you download the related tables from repeats? From the documentation here I have tried both (query) and query = "Creator = ${username}". When I did (query) I did not get any errors, but the related table info still did not download. I re downloaded the survey in the survey123 app and refreshed the inbox several times, still did not show up. When I tried query = "Creator = ${username}" I get the following error is Survey123 connect.

Re: Inbox query filter by username

JamesTedrick — Thu, 30 Nov 2017 18:58:06 GMT

Hi Alexis,

The blog post is for specifying the variables when setting the query for the parent form. At this point, we don't support variable insertion into the parameters column, so a repeat cannot be restricted to just the username while all parents are queried. I've added an enhancement request to support variables in that column.

Re: Inbox query filter by username

MichelleWilliams1 — Wed, 28 Aug 2019 16:11:07 GMT

Survey123 v 3.3.51 - I love the Inbox filter, but I broke it this morning.

I have two fields I'm filtering: UserAssigned=${username} OR UserAssignedNow=${username}

UserAssignedNow is for vacation employee swaps.

While testing the Inbox, the swapped employee will get the task in their inbox, but when we remove that person in Survey123, they still have the task in their inbox. Any help would be appreciated.

Complete filter: UserAssigned=${username} OR UserAssignedNow=${username} AND InsStatus='InProgress' OR InsStatus='FieldComplete' OR InsStatus='WaitingOnRepair'