Query folders when a path is given

Have following query that returns path based upon a select with "like" condition

Dim oObject As IDfSysObject = NothingDim oIDFQuery As IDfQuery = oClientx.getQuery

Dim ors As IDfCollection = NothingoIDFQuery.setDQL(

"select r_object_id, object_name, r_folder_path from dm_folder where object_name like '" & Folder & "%" + "'")ors = oIDFQuery.execute(oSession, tagDfQueryTypes.DF_READ_QUERY)

If ors IsNot DBNull.Value Then

While (ors.next()) myPath = ors.getString("r_folder_path").ToString DropDownList1.Items.Add(myPath)

End While

Now, using the returned path from above I need to do another query with a "like" condition looking for a sub folder(s). Not sure how to create a query wirh a given path. Thank you.

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

aflowers001

There are examples in the DQL manual but an example could be (from memory)

select r_object_id, object_name, r_folder_path from dm_folder where object_name like '%mysearchstring%' and FOLDER('/cabinet1/folder1/folder2',descend)

All comments

aflowers001

A simplistic solution would be to look at the FOLDER() DQL predicate in the manul. That could well do what you're after.

snufse-pujN6

Could someone give me an example of what the query string would like like, please.

aflowers001

There are examples in the DQL manual but an example could be (from memory)

select r_object_id, object_name, r_folder_path from dm_folder where object_name like '%mysearchstring%' and FOLDER('/cabinet1/folder1/folder2',descend)

jsilver

We're trying to discourage technical discussions in this forum. Please post all technical questions to either the Documentum Developer Community or the Documentum Support Forum. Your post is more likely to be seen and responded to in those locations.

See Please Read - Guidelines for Using This Discussion Forum for more information.

You are able to move this thread to the other forums. Select "Move discussion" from the Actions menu and select the appropriate forum, as described in the Guidelines.

Thanks,

Jerry

snufse-pujN6

That worked great, thank you.

oIDFQuery.setDQL(

"select r_object_id, object_name, r_folder_path from dm_folder where object_name like '%Reports%' and FOLDER('/Projects/Divison/South/General Projects/6004352 - Lane Shift Project',descend)")

One last question, is it possible to limit the query just to look at the 1st sub folder level under the "Folder" and not drill down to subsequent sub sub folders?

lastnitescurry

remove descend

check out folders section of

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