AnsweredAssumed Answered

Identifying changes using Geodatabase Archive Tables

Question asked by fannonj on Jun 5, 2015
Latest reply on Jun 17, 2015 by mike.robb

Hi

 

I have a requirement to identify changes to a versioned feature class since a given date. The feature class has archiving enabled and I have been looking at the documentation regarding this and have come up with the following queries which should enable detection of the deleted, modified and new features:

 

--DELETED

select OBJECTID, GDB_FROM_DATE, GDB_TO_DATE

from MYFC_H

where

  GDB_TO_DATE <> '9999-12-31' AND

  GDB_TO_DATE > '2015-06-05 00:00' AND

  OBJECTID not in (select OBJECTID from MYFC_H where GDB_TO_DATE = '9999-12-31')

 

--MODIFIED

select OBJECTID, GDB_FROM_DATE, GDB_TO_DATE

from MYFC_H

where

  GDB_TO_DATE <> '9999-12-31' AND

  GDB_TO_DATE > '2015-06-05 00:00' AND

  OBJECTID in (select OBJECTID from MYFC_H where GDB_TO_DATE = '9999-12-31')

 

--NEW

select OBJECTID, GDB_FROM_DATE, GDB_TO_DATE

from MYFC_H

where

  GDB_TO_DATE = '9999-12-31' AND

  GDB_FROM_DATE > '2015-06-05 00:00' AND

  OBJECTID not in (select OBJECTID from MYFC_H where GDB_TO_DATE <> '9999-12-31')

 

 

This appears to be working OK, based on some limited testing, but I was just wondering if anyone can verify the above or suggest a better way to do this using SQL (SQL Server) as I'm not sure the above is the most efficient SQL to achieve this.

 

Any input most welcome.

 

Regards

 

John

Outcomes