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

SanchezNuñez — Wed, 26 Jun 2024 11:21:59 GMT

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

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

MarlonAmaya — Mon, 08 Jul 2024 18:31:47 GMT

Hi @SanchezNuñez ,

I cant provide you with a query, however you can utilize Editor Tracking with traditional versioning to assist you.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/introduction-to-editor-tracking.htm

Branch versioning already has editor tracking built in automatically.

Marlon

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

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

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