I'm trying to utilize the Inbox for a survey with related tables. No matter what I put in the bind::esri:parameters field of my XLS form, when I try to specify any field in the query parameter, it fails and gives me a message like below.
query="date_inspected is null" allowUpdates=true
I can confirm, however, that the field does exist. I try for multiple fields, using every kind of SQL operator I can, and the result is the same.
Has anyone else encountered this?
Hi @jcarlson,
I believe the problem may be your query syntax. Can you please provide a copy of the XLSForm so we can take a closer look. Also, how is the Inbox configured in the survey settings, are you using a where clause query in the survey settings for Inbox also?
Please refer to: https://doc.arcgis.com/en/survey123/desktop/create-surveys/prepareforediting.htm#ESRI_SECTION1_80CFF...
And also note that only standardized queries are supported in AGOL. Refer to: https://doc.arcgis.com/en/arcgis-online/reference/sql-agol.htm#ESRI_SECTION1_39BB9CB4609D4F6480B746E...
Regards,
Phil.
I've referred to those sections in the past, but still see the same error messages.
The key cell on the repeat: allowUpdates=true query="pass_fail is null"
And on the survey settings itself, I have the query inspection_scheduling=1 which refers to a coded domain. This query works on its own, only showing me the "to do" permits. But trying to use a query to limit the repeats fails.