CODEWITHSUNDEEP
dqldocumentum
James
James

Reputation:

DQL return files in a Cabinet

Using DQL I want to return all the documents under the Cabinet test. How would I go about writing a query to do this?

Upvotes: 0

Views: 3581

Answers (2)

Kulveer Singh
Kulveer Singh

Reputation: 92

select * from dm_document where folder('/NameOfCabinet', descend); It will only return the current version of all the documents but not the all the version.

To see all the versions.

select * from dm_document(all) where folder('/NameOfCabinet', descend);

Upvotes: 1

heeen
heeen

Reputation: 4886

select r_object_id, object_name from dm_document(all) where folder('/NameOfCabinet', descend);

Upvotes: 3

Related Questions