Creating a view from versioned data

602
2
09-29-2021 05:40 AM
Labels (2)
AaronNash__GISP
New Contributor III

Hi, we wrote a view in SQL to link a bunch of tables together. View works as expected but it references the base tables. We can easily rewrite the view to access the versioned view _evw, but how to we set which version the view accesses?

We have default and 2 other versions in the tree

thanks

 

0 Kudos
2 Replies
George_Thompson
Esri Frequent Contributor

Take a look here; https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/read-sqlserver-versioned...

Not sure what RDBMS you are using, but there are others on the TOC of the help page.

--- George T.
AaronNash__GISP
New Contributor III

thanks for the link, we did review that page and it allows us view the versioned data in the select statement through SQL management studio. We can't write that code into the view statement in sql

0 Kudos