get document IDs of all versions of the same file

ossa
edited September 3, 2008 in Documentum #1

i have been searching this API :

EMC Documentum Foundation Services SDK 6.0 API Documentation

for a method to get the document IDs of all versions of the same file. it seems that there is no such method. anyone knows a way to do it ? I believe there is a very straight forward way. Appreciate your help !

-ossa

Comments

  • Francois Dauberlieu
    edited September 3, 2008 #2

    1st you need to get the chronicle ID of the document. this is a unique ID that spans all versions of the document and then you can use a query such as:

    select r_object_id from ALL where i_chronicle_id='[The cronicle ID to search for]'

  • ossa
    edited September 3, 2008 #3

    thanks btmsoftware . i will try it out and see whether there is anymore questions on this.

  • Francois Dauberlieu
    edited September 3, 2008 #4

    No problems. Just don;t forget to mark it as a good response if you're happy with it to get my points up

  • ossa
    edited September 3, 2008 #5

    Am i right to say that inside the dm_sysobject, r_object_id is the unique key which is the also the ObjectIdentity value in the API. i_chronicle_id is the one common across differernt versions ?

  • Francois Dauberlieu
    edited September 3, 2008 #6

    yes you are