Create database view which will show records of a feature class based on versioned view (from a specific child version in traditional versioning)

ZeusThompson

Hello Community,

I am searching for a way, so that I can create a database view which would dynamically update the records based on versioned view , however I would require to check those for a specific child version (as the edits are performed in child version).

I came across the following article ( https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/read-sqlserver-versioned-data-with-sql.htm) which mentions from SQL Server we can set the session to a particular child version and then run select statement to check the records within a particular feature class, however am unable to figure out how to create a database view out of this.

I would like to not perform reconcile/post and compress operation for updating the view as this would be a tedious task for our organization.

Any kind of help would be highly appreciated. 

DavidHoy

if you read that article carefully, you will see the example :

 

SELECT id, species, reporter
FROM sightings_ev
WHERE reporter = 'chuck';

 

the clue here is that the FROM clause is using the "Versioned View" that is already created in the geodatabase for any versioned class.

SO, you don't need to create a view - it should be there already. It will be named <featureclassname>_ev

If you want to use this _ev in your own view of a view - that should work (but won't be very fast and you won't be able to edit that view of a versioned view).