topic Re: Creating a view from versioned data in Geodatabase Questions

Creating a view from versioned data

AaronNash__GISP — Wed, 29 Sep 2021 12:40:07 GMT

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

Re: Creating a view from versioned data

George_Thompson — Wed, 29 Sep 2021 13:28:00 GMT

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

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

Re: Creating a view from versioned data

AaronNash__GISP — Wed, 29 Sep 2021 13:42:09 GMT

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