How To Get a Document's Version Stack Using DFS

rs199483

Hi Folks,

I want to be able to retrieve the entire version stack of a document using DFS and .NET. I've tried the below code but it only returns the CURRENT version.

If it's not possible using DFS then could you provide a DQL query and code sample?I'm using developer edition 6.5 sp1Dim objIdSet As ObjectIdentitySet = New ObjectIdentitySet()objIdSet.Identities.Add(objectIdentity)Dim vInfo As List(Of VersionInfo) = mobjVersionControlService.GetVersionInfo(objIdSet)For Each versionInfo As VersionInfo In vInfoConsole.WriteLine(versionInfo.Version)NextThanks

Find more posts tagged with

Comments

abc123

HI,

VersionControlService.getVersionInfo() should work. Make sure you have multiple versions, make sure you supplied correct object identity.

Anyway, it is possible to use DQL to get all versions (but with limitations). A sample DQL statement is:

SELECT * FROM dm_document (ALL) WHERE i_chronicle_id IN (SELECT i_chronicle_id FROM dm_document (ALL) WHERE r_object_id='%s')

The %s could be any revision id.

- Regards,

William

rs199483

Hi William,

Thanks for the reply. I guess what I was hoping for was to pass in a "document id" and be able to get all the revisions back (using version control services).

Is there such a thing as "document id" in documentum? Also, if I want all the properties and content that go with each revision, can i get that as well?

btw, the query works great.

Thanks

abc123

After I read the documentation again, I have to correct my previous comment: VersionControlService.getVersionInfo() just returns the version info for specific objects, not all versions. So what you found is the normal behavior.

The other question is "Is there a single call to get all versions with properties, contents, relationships, ...?" My answer is no. At least, you need to call DFS twice (1. get all revision IDs; 2. get all data by IDs.)

That's the reason why I said "but with limitation". Asterisk "*" in DQL only return part of single properties.

- Regards,

William