Filter Point Features By Related Table Records

[AKRRMapGuy]

We have a table that is related to a Feature Class by a Feature ID. The table contains inspection records, associated with one point in the point Feature Class. 

I am trying to make an EB app that filters the points and gives statistics aggregated by the Inspection Table values, such as inspection date. I can't figure out how to get the points to honor the table filters. Is this even possible? I have found some old posts that make it seem the related Feature functionality might end at pop ups?

We are using ArcGIS Enterprise 11.3, and the layers are referenced to SQL Server.

[Ke_Xu]

Hi @AKRRMapGuy,

If the point layer and table have common fields, you could try to use the Group Filter.

Thanks,

Ke

[AKRRMapGuy]

That's an interesting idea, If I default it to the 'max' date value it might give stats on only the newest records from the table. I am not sure if that is possible, but we will find out. The Feature ID would have to be the link I think, even though that isn't what we are filtering. 

[Ke_Xu]

Hi @AKRRMapGuy,

Group Filter allows the use of expressions. Currently, it is not supported to filter related Data directly by Filter. We will consider this requirement.

Thanks,

Ke

[AKRRMapGuy]

I really appreciate that. This functionality is very important for asset management. This matters for ArcGIS Dashboards too. The maintenance records are not the 'feature'. The maintenance records are related to the feature and contain all of the information about the condition and some other things. The ability to make the newest 'record' interactable both directions via the Feature is a huge deal.