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