Inbox Query for Related Records?

270
2
01-31-2020 09:08 AM
JimW
by
Occasional Contributor

I would like to be able to limit the number of points that my inbox displays based on an attribute in a related table.  Is it possible to create an inbox query expression that queries related records?

0 Kudos
2 Replies
JamesTedrick
Esri Esteemed Contributor

Hi Jim,

It isn't possible to use a related table within the definition query used to filter the inbox.

JimW
by
Occasional Contributor

Thanks for the reply.  Is this something that could be submitted as an enhancement?

I have a workflow with a one to many relationship.  The parent record stores the location of a repair (attributes of work order, address, town,etc.).  The child records store paving components, like a road, sidewalk or driveway, at the repair site.  Each of the components go through a series job statuses.  For example, they get marked out by our inspectors, a contractor schedules work and then marks it done and then we inspect the work and later on, certify it complete.  The child records at a repair location may each have a different job status and require multiple visits by our inspectors.  Our inspectors are assigned work depending on the job status.  For example, one inspector will handle mark outs while another handles inspections or certifications.  Currently, all repair locations show in the inbox regardless of the paving component job status.  The inspector selects a record from the inbox and then has to see what components are available, if any, in the related repeat.  I can filter the repeat based on job status but the inspector still has to go through the inbox, select a repair location and then see if there are any components.  We have hundreds of repair locations each year and they all show in the inbox.  What I would like to be able to do is to only show those repair locations in the inbox that have child records that match a certain job status so that my inspectors only see these repair locations in the inbox.  What they see there will only be what they need to inspect.  They won't have to look them up on a separate map or tap a repair location to see that there are no paving components for that particular repair location.  Is this something that could be done?

0 Kudos