Inbox Insists Related Table Fields Do Not Exist

Question

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?

jcarlson · Answer

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.

inspections_xls_copy.xlsx

Anonymous User · Answer

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_80CFFC9C38654DC293D4F36C5376C62E

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_39BB9CB4609D4F6480B746EF69CE1FF9

Regards,

Phil.