how to get all child folders of a particular user using dql

Vishalnp

Hi,

I want to retrive the top level folders inside cabinet to which user is having access using DQL query.

Thanks,

Vishal

Find more posts tagged with

Comments

aflowers001

try

select * from dm_folder where folder('/<<cabinet name>>')

i.e. for a cabinet named 'fred' the query would be

select * from dm_folder where folder('/fred')

Vishalnp

Hi Andy,

I am trying to retrive the folder to which user has access.

example: cabinet

--- Folder1 -- subfolder1

-- subfolder2

--- Folder2 -- subfolder1

-- subfolder2

--- Folder3 -- subfolder1

-- subfolder2

If user is having acces to subfolder2 of folder1 and subfolder1 of folder3 then i must only retrive the top folders that are folder1 and folder3 using dql query.

Thanks,

Vishal

abc123

The DQL literal folder(/<parent folder>) returns all accessible & direct child folders. In you case, Folder1 and Folder3 will be returned, in case Folder2 is not browseable. In most cases, you need to care only the direct child folders.

William

Imran_Yusubov

Hi,

There are several queries related to acl's whom you can combine and achieve to your goal.

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

Hope this helps