DQL-Documentum Query

Question

Can someone provide a solution in the Documentum Query Language for accessing the folder data of a file extracted from a document if we provide the object_id of the corresponding file. Thank...

Answer 1

You can try this dql: select * from dm_folder where r_object_id in (select i_folder_id from dm_document where r_object_id = '<objectId>')

Answer 2

You can simultaneously reset the object identifier in the API console. Team dump, c, you can see many attributes - more than DQL can provide you / Then find r_object_id Dump again and search I_folder_path you will swear

Answer 3

, . , , . :

select i_folder_id from dm_document where r_object_id='<objectid>'

i_folder_id. , . .

Answer 4

-

select * from dm_document where r_lock_owner not like ' '

r_object_id . -

select * from dm_folder where r_object_id in (select i_folder_id from dm_document where r_object_id = 'r_object_id')

, -

select distinct d.r_object_id,d.object_name, f.r_folder_path from dm_folder f,dm_document d where any d.i_folder_id = f.r_object_id and d.r_object_id in <'give r_object_id for checked out documents'> enable (ROW_BASED) 

Answer 5

, , , . r_folder_path , dm_folder, .

r_object_id, , DQL -

select      d.r_object_id, 
            d.title, 
            f.r_folder_path
from        dm_document d, dm_folder f
where       d.i_folder_id = f.r_object_id
and         d.r_object_id in 
(
    select      r_object_id
    from        dm_document
    where       r_lock_owner not like ' '
)
and f.r_folder_path not like ' '
enable      (row_based)

Answer 6

* dm_folder, r_object_id ( i_folder_id dm_document, r_object_id = [given_obj_id]);

dm_document, .

Answer 7

, , :

select distinct r_folder_path 
  from dm_folder 
 where r_object_id in
   (select i_folder_id 
      from dm_document
     where r_lock_owner is not nullstring)

: where r_lock_owner = '<name of owner>' <name of owner>.

Answer 8

select * from dm_sysobject
where r_object_id in (select i_folder_id from dm_sysobject where 
r_object_id='your _object_id')

owner detail s, type of the folder ( -), object type , , . , :

select * from dm_folder
where r_object_id=(select i_folder_id from dm_sysobject where 
r_object_id='your _object_id')