DQL Query to find the linked and copy documents

Hi All,

Need your help..

1.I wanted to write a DQL to find the list of documents names and ID's and distinct folderpaths to where they are linked by just specifying i_cabinet_id. Could you help me on this.

2.I also wanted to find out the DQL to find the list of folder paths by specifying the i_cabinet_id(data which I have)

3.Thirdly I also wanted to find out through DQL to find the list of virtual docs that have child documents in one cabinet and parent documents in another cabinet.

If you exprerts can help me in addressing the 3 queries seperately it would be very helpful for me.

Thanks

Vijay

Find more posts tagged with

Comments

Jasper

Hello Vijay,

Here's 1)

Select

doc.r_object_id, doc.object_name, fol.r_folder_path

from

dm_document doc, dm_folder fol

where

doc.i_cabinet_id='<i_cabinet_id>'

and fol.r_object_id=doc.i_folder_id

and fol.r_folder_path <> '' ENABLE (ROW_BASED)

Best regards

Jasper

Vijay Garudeswar

Thanks for the quick response

but when I run the below query i get the below msg

SelectMessage[DM_QUERY_E_REPEATING_USED]error: "You have specified a repeating attribute (i_folder_id) where it is not allowed."[DM_QUERY2_E_REPEAT_TYPE_JOIN]error: "Your query is selecting repeating attributes and joining types."Also can u confirm that this is the query to find the linked documents for the specified cabinet ID.ThanksVijay doc.r_object_id, doc.object_name, fol.r_folder_path from dm_document doc, dm_folder fol where doc.i_cabinet_id='0c0005d280a49b5d'and fol.r_object_id=doc.i_folder_id and fol.r_folder_path <> '' ENABLE (ROW_BASED);

Jasper

Hello Vijay,

The previous query worked on a 6.5SP2 environment, try query below this should not return any errors

SELECT docs.r_object_id
, docs.object_name
, fol.r_folder_path
FROM dm_sysobject_s docs
, dm_sysobject_r docr
, dm_folder_r fol
WHERE docs.r_object_id=docr.r_object_id
AND docs.i_cabinet_id='0c12d687800034a2'
AND fol.r_object_id=docr.i_folder_id
AND fol.r_folder_path <> ' '

This query returns all sysobjects with i_cabinet_id provided and the folder_path's they are linked to

Best regards

Jasper

Vijay Garudeswar

Hi Jasper,

Thanks for your response

I was also trying to find the third query I had put forth....

"I also wanted to find out through DQL to find the list of virtual docs that have child documents in one cabinet and parent documents in another cabinet."

I wanted particulary to find the cabinets list of the parent document of a virtual document whose child documents are there in another cabinet.Currently the data I have is only the cabinet ID.Is it possible to find this with the help of this data.

Thanks

Vijay

Jasper

Hello Vijay,

I'm no expert, but below query finds all virtual documents and child combination where p.i_cabinet_id<>c.i_cabinet_id.

select p.r_object_id as vd_id

, p.object_name as vd_name

, cabp.object_name as vd_in_cabinet

, c.r_object_id as vd_child_id

, c.object_name as vd_child_name

, cabc.object_name as vd_child_in_cabinet

from dmr_containment v, dm_sysobject p, dm_sysobject c, dm_sysobject cabp, dm_sysobject cabc

where p.r_object_id=v.parent_id

and c.r_object_id=v.component_id

and p.i_cabinet_id<>c.i_cabinet_id

and cabp.r_object_id=p.i_cabinet_id

and cabc.r_object_id=c.i_cabinet_id

Is this what you are looking for?

Regards

dnvhariprasad

Hi,

You can find DQLs at

http://www.dctmcontent.com/Lists/DQL/Category View.aspx

Verify whether there are any DQLs for your requirement.