We have the following:
The related table holds inspection data (many records for each Sewer Main record).
The SQL view filters down to only the single most RECENTLY DATED record from the inspection table for each Sewer Main feature.
Everything is working fine in Collector in connected mode.
The question I have is…can an MXD that contains a SQL view be published with SYNC capability (and thus be taken offline in Collector)?
Software: ArcGIS 10.3, Server 10.3, SQL Server
Thanks,
Jay
Solved! Go to Solution.
As an alternative - There have been posts here on how to use Arcade to change the symbols based on related records.
Edit: found it https://community.esri.com/thread/243196-dynamic-symbology-based-on-days-passed
As an alternative - There have been posts here on how to use Arcade to change the symbols based on related records.
Edit: found it https://community.esri.com/thread/243196-dynamic-symbology-based-on-days-passed