Query for what folders a specific group has permissions on

[wilkid]

Hi,

I'm looking to write a query that returns me a list of folders that a specific Livelink Group has access to (I couldn't find anywhere in the GUI that would show this so I'm assuming I need to write a query).

This is what I have so far, but, without being able to see what Folders a specific Livelink Group has access to via the interface, I can't validate that my query is returning the correct results.

select distinct
N.Nickname,
D.Name as FolderName,
k.Name as LivelinkGroup,
F.See
from DTreeACL as F
join KUAF as k on k.ID = F.RightID
join DTree as D on D.DataID = F.DataID
join Nickname as N on N.ID = D.DataID
where k.Deleted = 0
and D.SubType = 0

From this query, I can use the value for 'See' to determine what access the Livelink Group has to a specific Folder.

1) Is there a way to view what Folders a Livelink Group has access to via the GUI?
2) Is the above query the correct way to retrieve this info from the db?
3) Where can I find what the values in DTreeACL.See (0,1,2,3,4) represent?

Any help is greatly appreciated.

Thanks in advance,
Darrin

 

[ggriffit]

Darrin,
In answer to your questions :

1. At present there is no way to do this via the GUI

2. Your SQL does not look right, a quick look on the KC (

https://knowledge.opentext.com)

yields a few samples which may help :

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=3363653&objAction=view

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2257462&objAction=view&show=2

3. Check out the Schema Document (requires an NDA to be signed by your company, contact your OT Account Manager / Support for this document) Also check out page 24 of the Schema Companion Guide (

https://knowledge.opentext.com/know...008_Version_2).pdf?nodeid=13682418&vernum=-2)

which covers this.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/