Creating a view from versioned data

09-29-2021 05:40 AM
Labels (2)
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



0 Kudos
2 Replies
Esri Frequent Contributor

Take a look here;

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

--- George T.
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