How to search the files in a folder

Hi,

i am looking for a DQL query which will search for the content in a perticular folder.

i am using the below query for getting the contents in a cabinet. i want to search the contents in a perticular folder, i know the folder id.

select r_object_id, object_name, r_object_type from idox_document search topic 'test' where (i_cabinet_id <> '0c0014d290000106') order by object_name.

thanks & regards,

satdmail

Find more posts tagged with

Comments

Francois Dauberlieu

select blabla from blabl where folder('/myfolder/mysubfolder') will search only in this folder

select blabla from blabl where folder('/myfolder/mysubfolder',descend) will search in this folder and ALL sub-folders. Careful, can be long in a complex folder structure

Also, I recommend you get hold of the DQL guide from the Documentum Download Center (If my memory serves me well, it is in the Content Server area but I'm not sure)

kodnam

If you have folder ID with you, you can also use a DQL like the following to get the necessary documents

select * from dm_document where FOLDER( ID ('XXXXX'))

or select * from dm_document where FOLDER ( ID ('XXXX') , DESCEND)

My advice is to get the DQL reference guide for content server .