Can the where clause in the inbox query repeat records? I'm getting a Code 500 error when refreshing the inbox.
Hi Glen,
Yes, you can query repeat records using the bind::esri:parameters column on the begin repeat question type in the XLSForm. See this doc article for more information: Prepare for editing existing survey data—ArcGIS Survey123 | Documentation
Ae you using AGO or Enterprise (Portal) and if so what version? Are there any other details with the Code 500 error, are you able to enable diagnostic logs and start logging when you refresh the Inbox to see if any additional information in the logs.
Regards,
Phil.
Hi. Philip,
I didn't have the bind::esri:parameters set to query so I changed it. After republishing the error code changed to 400.
I am publishing to Enterprise (portal) 10.7.1.
I searched the log for the error(see below). It looks like it wants to search the parent feature service and not the child for the inbox where clause. layer 4 in the URL is the parent not the related table I would like the where clause to limit the inbox to.
PortalRequest: PortalRequest failed url: https://gis.fdacs.gov/mapping/rest/services/DPI/M_INDICA_DPI_PI_PROD/FeatureServer/4/query error: { "code": 400, "details": [ "Unable to perform query operation." ], "message": "Unable to complete operation."
Am i trying to do something that isn't supported or do I have to format the where clause differently? My where clause is inspection_status='pending'. inspection_status is a field in the relate in which I'm trying to store a QA status of a inspection that reoccurs at a location.
Thanks,
Glen
What is the exact expression you are using in the bind::esri:parameters column?
It should look similar to: query="inspection_status='pending'"
Also, if you want to allow updating existing records you need to use: allowUpdates=true
By default adding records is allwoed, but if you want to not allow adding new records, you can set that to false.
The bind::esri:parameters column is :
query="inspection_status='pending'" allowUpdates=true allowAdds=false
And my inbox settings are:
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
