Creating a view from versioned data

[AaronNash__GISP]

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

[George_Thompson]

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.

[AaronNash__GISP]

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