Get previous version content of a document

Hi,

I'm training with DFS and document versions. I create a new document (objectID), then I create some new versions of the document.

I'm able to retrieve all versions created with:

select r_object_id, r_creation_date, **** from dm_document (all) where i_chronicle_id = '...'

If I search documentum for a previous version r_object_id it doesn't found anything.

using select * from <my_document_type> (all) where r_object_id = '<previous_version_id>' my search returns the line.

How can I do to get the content of a previous version? The code I use is this, but DataObiects.Count is always 0.

ObjectIdentity _ID = new ObjectIdentity (new ObjectId (<version_object_id>), _defaultDocbase);

_ID.RepositoryName = _defaultDocbase;

ContentTransferMode trMode = ContentTransferMode.MTOM;

ContentTransferProfile transferProfile = new ContentTransferProfile ();

transferProfile.Geolocation = "Pleasanton";

transferProfile.TransferMode = trMode;

_serviceContext.SetProfile (transferProfile);

ContentProfile _cp = new ContentProfile ();

_cp.FormatFilter = FormatFilter.ANY;

OperationOptions _oo = new OperationOptions ();

_oo.ContentProfile = _cp;

_oo.SetProfile (_cp);

ObjectIdentitySet _idSet = new ObjectIdentitySet ();

List<ObjectIdentity> _idList = _idSet.Identities;

_idList.Add (_ID);

DataPackage _dp = _objectService.Get (_idSet, _oo);

if ( _dp.DataObjects.Count == 0 )

{

<this is always 0>

Thank you in advance

Aqualung

Find more posts tagged with

Comments

DCTM_Guru

If you are already getting list of object IDs from the first query, why are you running the 2nd query? I also noticed that your 1st query is querying dm_document and your 2nd query is querying my_document_type. So you are using the same i_chronicle_id in both, then that means that your object type is dm_document (not my_document_type).

ConteBracco

Hi,

the first query is on dm_document to get all versions of a document (all i_chronicle_ids). The second query is querying my_document_type with one of the r_object_ids of a previous version (not the current). All queries on previous r_object_ids return 0 records found.

Thank you

DCTM_Guru

You should not be mixing document types. Either stick with dm_document or change your original query to reference your custom type:

select r_object_id, r_creation_date, **** from my_document_type (all) where i_chronicle_id = '...'

This will eliminate any sort of confusion.

ConteBracco

Sorry,

maybe I was not clear. I need to retrieve documentContent (bits) of a previous version.

This is my problem.

I know the use of chronicle_id and r_object_id. I have 7 version of a document. My need is to save the PDF (this is the format) of the version number 4 (of 7) on my disk.

I only tried to describe the environment.

1. I know that my document has 7 different versions

2. I'm able to read r_object_id of each version

3. I need to retrieve the binary data of one of the previous versions (not the current one)

That's all.

DCTM_Guru

It may be that DFS operation doesnt support previous version. If you have r_object_id of all 7 versions, then you dont need the second query.

Ashishtcs

DQL to get all non-current versions of documents...

Select r_object_id, object_name, r_version_label, r_current_state, .... from dm_docuement (all) where i_chronicle_id='<>' and r_object_id not in (Select r_object_id from dm_docuement where r_object_id='<>' ) ;

Trick

Here outer query will return all versions (Current Version+ Non current version) information and the inner query will return only current versions information and we can pass current version r_object_id to "not in " condition to prevent current versions in final results set.

Thank you

DCTM_Guru

Hi Ashishtcs

If you want to get non-current versions, you don't need to do inner join, just use i_latest_flag

Select r_object_id, object_name, r_version_label, r_current_state, .... from dm_docuement (all) where i_chronicle_id='<>' and i_latest_flag=false

Much more speedier query