Inbox Query Expression for Related Attributes

388
1
12-06-2018 05:18 AM
JimW
by
Occasional Contributor II

I have a AGOL hosted feature layer that has a parent feature class (Repair Locations) and a related child feature class (Paving Cut Details).  There can be one - three paving cuts at each repair location and each paving cut can have a different job status.  If there are three paving cuts at one repair location, there will be three points, each with a different job status.  I only want the Survey123 inbox to display those repair locations that have paving cuts with a job status of 'received'.  However, the job status is an attribute of the paving cut layer and not the repair location layer.  Currently, the inspector sees all repair locations regardless of the status of the related paving cuts.  I have a query set in the bind::esri:parameters column for the correct job status on the related child layer but the inspector has to select a repair location to see if there are any paving cuts with the job status of received.  It would be much better for our inspectors if I could set an inbox query that would only show those repair locations that having paving cuts with a job status of received.  I tried something like this:  RepairLocations.Town='Hartford' AND PavingCutDetails.JobStatus=1 but get a Code 400 Cannot perform query.  Invalid query parameters.  when I refresh my inbox.  Is this a limitation of standardized queries?  Is what I want to do possible?  Thanks.

0 Kudos
1 Reply
FranciscoAndrade1
Occasional Contributor

I am looking into something similar too.

I am looking to create a survey based of a previously created feature service. The feature class has related tables. I would like for the users to be able to download the feature class and the related table. The related table data is not being downloaded. Is it possible to download the related table data along with the feature class? I would like for the user to be able to view the pictures taken at the time the record was created.

Please see attached images

0 Kudos