Need report which shows items an permission of selectable folder and next two subfolder

Hello,I need report which shows items an permission of selectable folder and next two subfolder. Maybe as an Modification of https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=4463668&objAction=view&show=2 .We have Livelink 9.5.0 with OracleThanks in advance !Peter

Find more posts tagged with

Comments

Tim_Hunter

Not sure what you are asking, what about the referenced report does not meet your needs?

Peter Stegl

the refernced report shows all items in all subfolder inclusiv the folders. We need an report to find the permissions of the fist two top level folders and its items. Because we are respnsible for it. All follwing subfolders are Managed by the users.

Tim_Hunter

The key to the query you referenced is understanding how the recursion in oracle works. Understanding "START WITH" and "CONNECT BY PRIOR" is what makes the query give you the structure of the folder. The start with .. connect by clause can be used to select data that has a hierarchical relationship which is how folders are stored in Livelink dtree.If you edit the subquery from (SELECT DATAID FROM DTREE START WITH DATAID = %1 CONNECT BY PRIOR DATAID = PARENTID )to(SELECT DATAID FROM DTREE where level <= 2 START WITH DATAID = %1 CONNECT BY PRIOR DATAID = PARENTID )you can limit the recursive folders (levels) to however deep you require. In my example I made it 2.