Does anybody know the query to get the latest of ALL records in a versioned SDE geodatabase (including records from the add and delete (A&D) tables? I'm specifically looking for SQL Server.
Read versioned data in SQL Server using versioned views—Help | ArcGIS for Desktop
This link should give you the idea.
Thanks Gupta for quick response.
Versioned views holds the data only after the versions are "reconcile & post" to default.
Is there any query/method to get the all the records before i post it to default?
Instead of querying the Feature Classes or Tables, try to pull the updated data from the Versioned views. Versioned view will show data from the Base\Business Tables and the Delta Tables both, which is what you need.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
