DQL return files in a Cabinet

Question

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

score 3 · Accepted Answer · answered Feb 06 '09 at 12:12

3

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

answered Feb 06 '09 at 12:12

heeen

4,736
2
21
24

I'm not sure if I agree with the all predicate, as this will return all versions, not just current versions. – shsteimer Feb 06 '09 at 19:28
You say that like it's a bad thing, shsteimer :) – Sheldon R. Oct 14 '14 at 20:04

score 1 · Answer 2 · answered Mar 02 '12 at 17:56

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);

DQL return files in a Cabinet

2 Answers2