topic Re: No data in database view of versioned feature class in Geodatabase Questions

No data in database view of versioned feature class

ChrisWiebke — Thu, 29 Aug 2019 20:29:38 GMT

If I have a view of versioned data how do i get the view to return data before the feature class it references is reconciled with the default version of the geodatabase?

Re: No data in database view of versioned feature class

George_Thompson — Fri, 30 Aug 2019 11:48:28 GMT

You need to be set the version that you want to see in the view; Read versioned data in SQL Server using versioned views—Help | ArcGIS Desktop

That should get you what you want.

Re: No data in database view of versioned feature class

ChrisWiebke — Fri, 30 Aug 2019 13:13:48 GMT

I am able to do that in a ssms query window, but the view I created always reads from default. I would like to be able to specify which version of the geodatabase the view reads from. Thanks.

Re: No data in database view of versioned feature class

George_Thompson — Fri, 30 Aug 2019 13:36:42 GMT

You need to create a view in SSMS and put that SQL to change the version in the view.

Re: No data in database view of versioned feature class

ChrisWiebke — Sun, 12 Dec 2021 10:26:52 GMT

I used this to create the view:

USE [Our Database]
GO

EXEC database.sde.set_current_version 'the version'

/****** view info******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

but when I script out the view to a new query window, the exec is not there:

USE [Our Database]
GO

/****** view info******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

is there something else I need to do?

Thanks.