topic Querying INBOX in ArcGIS Survey123 Questions

Querying INBOX

Anonymous User — Thu, 22 Mar 2018 05:58:01 GMT

Hi all,

How could I query empty values for a particular question?
According to this article, I should be able to use Creator={$username} to query all records created by the currently signed-in user. But, I get this error instead.

Any suggestions

Thanks,

Gee

Re: Querying INBOX

Anonymous User — Thu, 22 Mar 2018 06:05:06 GMT

Hi Geethaka,

Note there is an error in the current online documentation regarding the syntax used in the example. The $ is in the wrong place, it should follow the same format used in the xlsx form. The correct syntax is:

Creator=${username}

This has already been fixed in our next release of online documentation and will be updated with the 2.7 release.

Regards,

Phil.

Re: Querying INBOX

Anonymous User — Thu, 22 Mar 2018 11:00:21 GMT

Thanks, that worked

I have a select_one yes_no question, where I want to query all results that aren't yes. (i.e. Not equal to 'yes' OR equal to 'no' or 'empty')

Could you please explain how I could get this query to work in INBOX?

Sorry, I just couldn't get it to work (after multiple attempts)....

Thanks.

Re: Querying INBOX

Anonymous User — Sat, 24 Mar 2018 21:05:07 GMT

^^^ Any suggestions on the above?

Thanks

Re: Querying INBOX

Anonymous User — Sun, 25 Mar 2018 23:45:34 GMT

Hi Geethaka,

By default the Inbox query only supports Standardized Queries as per the settings enabled on the organization by your Administrator. In our 2.7 release (end March) we have updated the documentation for the Inbox query. Here is a snippet of that updated documentation:

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

-------------------------------------------------

Additional documentation:

These queries also support SQL logical operators, allowing the query to perform more complex searches based on specific criteria. This example will return only results from users whose user names contain the user name of the logged-in user, as well as any text before or after it.

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

The following operators are supported by Survey123.


Operator	Description
ALL	True if all of the subquery values meet the condition.
AND	True if all the conditions separated by AND are true.
ANY	True if any of the subquery values meet the condition.
BETWEEN	True if the operand is within the range of comparisons.
EXISTS	True if the subquery returns one or more records.
IN	True if the operand is equal to one of a list of expressions.
LIKE	True if the operand matches a pattern.
NOT	Displays a record if the condition or conditions are not true.
OR	True if any of the conditions separated by OR are true.
SOME	True if any of the subquery values meet the condition.

Caution:

To run queries using logical SQL operators, your organization's administrator must disable the Standardized Query security option for your organization to allow nonstandard SQL queries. For more information on the ramifications of disabling this option, see about standardized queries in the ArcGIS Server documentation. For more information on standard and nonstandard queries, see standardized SQL functions in ArcGIS Online

Re: Querying INBOX

Anonymous User — Tue, 27 Mar 2018 23:59:34 GMT

Hi Philip Wilson‌, James Tedrick‌,

Could you please provide a simple example using the NOT operator (i.e. Not equal to 'yes') that I could use to query INBOX results?

Thanks,

Gee

Re: Querying INBOX

Anonymous User — Wed, 28 Mar 2018 00:12:34 GMT

Have you disabled the Standardized Query security option?

Re: Querying INBOX

Anonymous User — Thu, 29 Mar 2018 03:44:12 GMT

No, we wouldn't disable it due to the potential vulnerabilities.

Is there another way to query without disabling the Standardised Query security option?

Thanks

Re: Querying INBOX

Anonymous User — Sun, 01 Apr 2018 20:14:20 GMT

Thanks Philip Wilson‌ for the help.

I'm thinking of creating a survey on top a "hosted feature layer" and definining features accordingly.

P.S. any updates on when the next version of Survey123 will be released

Thanks

Re: Querying INBOX

IsmaelChivite — Mon, 02 Apr 2018 04:13:18 GMT

Hi geethaka.fernando_ACTGOV‌,

version 2.7 is planned to be made available on April 3.

Re: Querying INBOX

Anonymous User — Tue, 03 Apr 2018 01:42:38 GMT

Hi Geethaka, unfortunately not, the only way to run queries using logical SQL operators is to disable that security option. This is controlled by AGOL/Portal organization settings and not something we can over-ride in the Survey123 app.

Phil.

Re: Querying INBOX

Anonymous User — Fri, 27 Jul 2018 11:48:17 GMT

Quick Question on this subject matter. I had a survey with the inbox enabled and the following "query allowUpdates=true" within the "bind::esri:paramters" column for a repeat that gave us the ability to pull all data and update values for the survey.

After the update to Version 3.0 we can no longer use the "Inbox" to update our data within repeats? Can you provide any feedback on what has happened as I am following the this help documentation - Prepare for editing existing survey data—Survey123 for ArcGIS | ArcGIS

Thanks!

Mike

Re: Querying INBOX

Anonymous User — Fri, 27 Jul 2018 11:58:21 GMT

Try deleting and re-downloding the survey.

That did the trick for me.

Gee

Re: Querying INBOX

Anonymous User — Fri, 27 Jul 2018 16:17:43 GMT

Unfortunately, I just tried that and I am not having any success. Thanks for the suggestion.

Re: Querying INBOX

BrandonArmstrong — Fri, 27 Jul 2018 23:08:38 GMT

Hi Mike,

If you are able, can you please share your XLSForm? Feel free to send it in a private GeoNet message after clicking on my name.

Thanks,

Brandon

Re: Querying INBOX

BrandonArmstrong — Tue, 31 Jul 2018 18:01:23 GMT

Hi Mike,

Thank you for sending over your XLSForm. As we discussed, one thing that was noticed is that the parameter specified in the bind::esri:parameters column for the begin repeat question type of your first repeat was set as 'allowUpdates=true query'. It was recommended that this be changed to 'query allowUpdates=true'.

After republishing your survey and downloading to the Survey123 field app, you have reported that the behavior remains the same.

For clarification, is the inability to edit repeats from the Inbox seen with all repeats, or just those that have a relevant statement applied?

If you have not seen the following GeoNet thread, there is currently a known issue involving the inability to edit the first record within a repeat when attempting to do so via the Inbox/Sent/Draft folders.

Best,

Brandon

Re: Querying INBOX

Anonymous User — Tue, 31 Jul 2018 18:37:27 GMT

Hello Brandon,

I applied the above fix and I am still still experiencing the behavior of the repeat data not being queried within the inbox. However, this is occurring for all of the repeats within the survey form and not the one that had the incorrect query string. We have three separate repeats that contain multiple entries within them and none of the data has been pulled into the inbox survey forms.

However, we are "not" experiencing the issue of not being able to edit the first record of the repeats within the following workflow -> open a survey from the draft folder, choose option copy into a new form, and then the field crews will delete all entries into the last two repeats and not the geopoint repeat; as it contains the locations that are needed from the previous survey.

Thanks for the reply,

Mike

Re: Querying INBOX

BrandonArmstrong — Mon, 06 Aug 2018 16:57:14 GMT

Hi Mike,

As mentioned via email, I have verified several times that I can use your XLSForm to create a new survey (with either Survey123 Connect 2.7 up to 3.0), download the survey to field app 3.0, submit records, and then open Inbox and edit repeats.

It might be helpful if you could capture a log during the attempt to open and edit one of your records containing values within your repeat questions, and send my way. Troubleshoot—Survey123 for ArcGIS | ArcGIS (select the option to log to a file)

Thanks,

Brandon

Re: Querying INBOX

Anonymous User — Tue, 14 Aug 2018 00:35:20 GMT

Brandon,

I have been on PTO for the last week and I am just now seeing this. I am baffled as to why this behavior would be occurring; as I tweaked and republished according to your recommendations. The fact that you can publish in house with my materials and not have the behavior that I am experiencing; dumbfounded.

We have hit the busy season of processing the data that we have captured most of the summer and now I need to turn my attention to the processing and exporting of the reports for the data that was captured. I may have to come up with a post-processing routine in order to generate the report forms that we need for our reporting with fill-able PDF files, due to the complexity of my templates.

I will circle back around at some point to try and republish the survey under a different name to test the related table behavior. I do appreciate the input. Eventually, things will catch up to each other.

Thanks!

Mike

Re: Querying INBOX

Jack_Zhang — Thu, 24 Jan 2019 08:34:59 GMT

Hi Philip and others, I'm afraid the example of use Like Operator and ${username} Creator LIKE '%' + ${username} + '%' which you mentioned and also documented at Prepare for editing existing survey data—Survey123 for ArcGIS | ArcGIS didn't work for me at all. Actually I'm not quite sure if the syntax is correct, why the % need be singled quoted? I couldn't find anywhere on REST API or other doc explained why the % need be singled quoted. It works fine if my query is like userid = ${username}, or userid LIKE '%jack%', where userid is the field in my form that captures the Portal user name. However, I got 500 Error (invalid where clause) when tried userid LIKE '%' + ${username} + '%' , I also tried userid LIKE '%${username}%' it didn't throw error but no result returned either.

Is it mandaroy to disable the Standarzed Query in order to make the LIKE operator and the ${username} varible working? I found the help page didn't clearly explain it.