AnsweredAssumed Answered

Save Multi-Versioned Spatial Views

Question asked by jhodny@Newark.de.us_CityOfNewarkDE on Mar 27, 2020
Latest reply on Mar 30, 2020 by jhodny@Newark.de.us_CityOfNewarkDE

We are having trouble creating a spatial view on a versioned dataset in attempt to link the most recent inspection (stored in a SDE related table) with an Asset (SDE Feature Class).  The relationship class is a one to many as there can be multiple inspections over time occurring at the same asset location.  We can create SQL queries in SQL Server using the setcurrentversion() stored procedure; however, we can’t figure out how to incorporate that stored procedure into creating and saving a new View (if this is even possible?).  Our current SDE database structure is multi-versioned, e.g.,  Default – QA – Edit.   Ideally, we would have a spatial view linked with the edit version so that we can dynamically symbolize (i.e. days since last inspection) for field staff to prioritize locations and see real-time updates.  We use ArcGIS for Server 10.7.1 and our SQL Server geodatabases at are 10.7.1, as is our ArcMap clients.  Pro is at the latest released version.

Outcomes