DQL query for getting document.

Hai

I have document with 5 version like 1.0,1.1,1.2,2.0,3.0. I have the ObjectId of 3.0 then I need to get the details of 1.1 how can I get those plz any one help me regarding this.

Find more posts tagged with

Comments

Hari-HSC

select r_object_id from custom_type(all) where object_name='xyz'.

this will display you all the version available.

gcampos

I wouldn't rely on object_name, I prefer to use i_chronicle_id, which is the r_object_id of the first object in the version tree, and it's stored in all objects, so you could try:

select i_chronicle_id from dm_document where r_object_id = '<the id you already have>'

select * form dm_document (all) where i_chronicle_id = '<the i_chronicle_id obtained in the previous query>'

optionally you could add: and any r_version_label = '1.1'

Regards

Miller-zzMST

Hi!

Try this:

SELECT r.r_object_id
FROM   dm_sysobject_r r, <type of document> (ALL) d 
WHERE  r.r_object_id     = d.r_object_id 
  AND  r.r_version_label = 'version label' 
  AND  d.object_name     = '<object name>'

As <version label> you can use or a number (like 1.0, 1.1, etc) or a name enterd by user.

-- Konstantin

Miller-zzMST

Gustavo,

dnvhariprasad

Try this query

select * from dm_document (all) where i_chronicle_id = (select i_chronicle_id from dm_document where r_object_id  = 'your object id')