Inbox Insists Related Table Fields Do Not Exist

191
2
07-30-2021 03:13 PM
jcarlson
MVP Regular Contributor

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

jcarlson_0-1627682902222.png

 

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?

- Josh Carlson
Kendall County GIS
0 Kudos
2 Replies
Philip-Wilson
Esri Frequent Contributor

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.

0 Kudos
jcarlson
MVP Regular Contributor

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.

- Josh Carlson
Kendall County GIS
0 Kudos