Select to view content in your preferred language

How to differentiate new records from updated records made in a SDE version

79
0
Wednesday
Labels (2)
SanchezNuñez
Occasional Contributor

Good morning

Is there a way to differentiate between records added and records updated in traditional or branch versions?

I tried this code, but I did not see a way to differentiate them:

SELECT [MyRecordID], additional fields, ...
FROM [SchemaOwner].[a4313]
WHERE SDE_STATE_ID IN
(SELECT STATE_ID
FROM SDE.sde_STATES
WHERE LINEAGE_NAME IN
(SELECT LINEAGE_NAME
FROM SDE.sde_STATES
WHERE STATE_ID =
(SELECT STATE_ID FROM SDE.sde_VERSIONS WHERE NAME ='MyVersion'
)
)
)

Thanks

 

0 Kudos
0 Replies