Tree View of Folders under a Particular Folder

I was wondering if anyone can help me in creating a livereport that will display a tree view of the folder structure under a particular folder in Livelink..Any help would be v. much appreciated.Thanks,Amina.

Find more posts tagged with

Comments

Herman__Linder_(Herman_(Delete)_2300286)

I guess that you want a report that shows all subfolders and documents. The problem is that sql doesn't provide this functionality, so a livereport can't accomplish this. You could use xmlexport + a stylesheet or use:llisapi.dll?func=projects.projectoutline&objId=195319just replace the objid with the id of the folder you wish to traverse! regards/Herman

eLink User

Message from via eLinkThis is a poor solution but I found the easiest way to do this is using theURL /livelink/livelink.exe?func=Projects.ProjectOutline&objid=. This will work outside of a Project and will list a very niceview of the structure. The only problem with it is, it takes a long time togenerate (experiment at a lower level folder) and you cannot filter out itemtypes (it lists everything, not just folders). It would be nice if Opentextfully supported this with an interface option to do this for any folder. If this method isn't what you want and you really want a live report then ifyou are using Oracle there is something like Connect by Prior that will helpyou out (lots of information in this discussion about that) but on SQLServer, you will have to write a Stored Procedure and call it from Livelink.We use SQL Server and I have written a stored procedure to give me a list offolders under a given folder but it will only list folder level and theparent ID so you have to trace through it to find the real hierarchy still.Also I don't call it from Livelink due to the limited scope of its use. Ionly use it to extract all DataID of folders in a given branch of a tree soI can then analyze that data further (Who assigned permissions toindividuals rather then groups, what folders have delete rights and also alot of Children in them, how name empty folders are there in a givendivision etc.)I hope this helps.________________________________________Stephen FisherKnowledge Management Systems SpecialistAstraZeneca Canada Inc.________________________________________-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: February 5, 2003 6:01 AMTo: eLink RecipientSubject: Tree View of Folders under a Particular FolderTree View of Folders under a Particular FolderPosted by PremOilAdmin on 02/05/2003 05:55 AMI was wondering if anyone can help me in creating a livereport that willdisplay a tree view of the folder structure under a particular folder inLivelink..Any help would be v. much appreciated.Thanks,Amina.[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

eLink User

Message from Mohsin Jessa via eLinkHi Amina,Here is an oracle specific solution that may work for you.1) Listing the hierarchy of folders from a given point (in this case thedataid=17493)select level, dataid, parentid, substr(Lpad(' ',level-1)||name ,1,40) "Folder Name"from dtreewhere subtype in (0) /* Will just print the folder structure */connect by prior dataid = parentidstart with dataid=17493ORDER BY ROWNUM/ LEVEL DATAID PARENTID Folder Name---------- ---------- ---------- ---------------------------------------- 1 17493 11003 Test's Folder Top Level 2 17494 17493 Test's Folder Level 2 3 17508 17494 Folder Level 3 4 17509 17508 Folder Level 4 2 17501 17493 Another Folder below the top2) This one lists the hierarchy of folders and the documents it containsstarting from a given point (i.e. dataid=11003)select level, dataid, parentid, substr(Lpad(' ',level-1)||name ,1,40) "Folder/Document Name"from dtreewhere subtype in (144,0) /* Will print the folder structure and theirdocuments only */connect by prior dataid = parentidstart with dataid=11003ORDER BY ROWNUM/ LEVEL DATAID PARENTID Folder/Document Name---------- ---------- ---------- ---------------------------------------- 2 17493 11003 Test's Folder Top Level 3 17494 17493 Test's Folder Level 2 4 17498 17494 MPower Text File - Level 2 4 17508 17494 Folder Level 3 5 17509 17508 Folder Level 4 6 17510 17509 Population queries 6 17513 17509 SQL Best practices document 3 17495 17493 Bounce LL Batch File - Level 1 3 17501 17493 Another Folder below the top 4 17502 17501 Export commands 3 17505 17493 Logminer setup 2 17516 11003 Startup LL90 batch file3) This sql generates a report of just the documents contained in the folderhierarchy starting from a given folder with dataid-17493select level, dataid, parentid, substr(Lpad(' ',level-1)||name ,1,40) "Document Name"from dtreewhere subtype in (144) /* Will just print the documents only */connect by prior dataid = parentidstart with dataid=17493ORDER BY ROWNUM/ LEVEL DATAID PARENTID Document Name---------- ---------- ---------- ---------------------------------------- 3 17498 17494 MPower Text File - Level 2 5 17510 17509 Population queries 5 17513 17509 SQL Best practices document 2 17495 17493 Bounce LL Batch File - Level 1 3 17502 17501 Export commands 2 17505 17493 Logminer setup6 rows selected.Hope this helps.MohsinOracle Technical Specialist.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, February 05, 2003 8:14 AMTo: eLink RecipientSubject: RE Tree View of Folders under a Particular FolderRE Tree View of Folders under a Particular FolderPosted by eLink on 02/05/2003 08:14 AMMessage from via eLinkThis is a poor solution but I found the easiest way to do this is using theURL /livelink/livelink.exe?func=Projects.ProjectOutline&objid=. This will work outside of a Project and will list a very niceview of the structure. The only problem with it is, it takes a long time togenerate (experiment at a lower level folder) and you cannot filter out itemtypes (it lists everything, not just folders). It would be nice if Opentextfully supported this with an interface option to do this for any folder.If this method isn't what you want and you really want a live report then ifyou are using Oracle there is something like Connect by Prior that will helpyou out (lots of information in this discussion about that) but on SQLServer, you will have to write a Stored Procedure and call it from Livelink.We use SQL Server and I have written a stored procedure to give me a list offolders under a given folder but it will only list folder level and theparent ID so you have to trace through it to find the real hierarchy still.Also I don't call it from Livelink due to the limited scope of its use. Ionly use it to extract all DataID of folders in a given branch of a tree soI can then analyze that data further (Who assigned permissions toindividuals rather then groups, what folders have delete rights and also alot of Children in them, how name empty folders are there in a givendivision etc.)I hope this helps.________________________________________Stephen FisherKnowledge Management Systems SpecialistAstraZeneca Canada Inc.________________________________________-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: February 5, 2003 6:01 AMTo: eLink RecipientSubject: Tree View of Folders under a Particular FolderTree View of Folders under a Particular FolderPosted by PremOilAdmin on 02/05/2003 05:55 AMI was wondering if anyone can help me in creating a livereport that willdisplay a tree view of the folder structure under a particular folder inLivelink..Any help would be v. much appreciated.Thanks,Amina.[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: Tree View of Folders under a Particular Folderhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2961591&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

eLink User

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

The trouble I've had with things like LPad() is that while it works well outside of a LiveReport, the LiveReport kindly strips the extra spaces away, leaving me with an unindented list. Have you seen this behavior too? I haven't tried prefixing the LPad() with a character like "*" -- maybe that would work.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, February 05, 2003 12:06 PM
To: eLink Recipient
Subject: RE RE Tree View of Folders under a Particular Folder

RE RE Tree View of Folders under a Particular Folder Posted by eLink on 02/05/2003 01:06 PM
In reply to: RE Tree View of Folders under a Particular Folder Posted by eLink on 02/05/2003 08:14 AM

Message from Mohsin Jessa <mjessa@opentext.com> via eLink

Hi Amina,

Here is an oracle specific solution that may work for you.

1) Listing the hierarchy of folders from a given point (in this case the
dataid=17493)

select level,
dataid,
parentid,
substr(Lpad(' ',level-1)||name ,1,40) "Folder Name"
from dtree
where subtype in (0) /* Will just print the folder structure */
connect by prior dataid = parentid
start with dataid=17493
ORDER BY ROWNUM
/

LEVEL DATAID PARENTID Folder Name
---------- ---------- ---------- ----------------------------------------
1 17493 11003 Test's Folder Top Level
2 17494 17493 Test's Folder Level 2
3 17508 17494 Folder Level 3
4 17509 17508 Folder Level 4
2 17501 17493 Another Folder below the top

2) This one lists the hierarchy of folders and the documents it contains
starting from a given point (i.e. dataid=11003)

select level,
dataid,
parentid,
substr(Lpad(' ',level-1)||name ,1,40) "Folder/Document Name"
from dtree
where subtype in (144,0) /* Will print the folder structure and their
documents only */
connect by prior dataid = parentid
start with dataid=11003
ORDER BY ROWNUM
/

LEVEL DATAID PARENTID Folder/Document Name
---------- ---------- ---------- ----------------------------------------
2 17493 11003 Test's Folder Top Level
3 17494 17493 Test's Folder Level 2
4 17498 17494 MPower Text File - Level 2
4 17508 17494 Folder Level 3
5 17509 17508 Folder Level 4
6 17510 17509 Population queries
6 17513 17509 SQL Best practices document
3 17495 17493 Bounce LL Batch File - Level 1
3 17501 17493 Another Folder below the top
4 17502 17501 Export commands
3 17505 17493 Logminer setup
2 17516 11003 Startup LL90 batch file

3) This sql generates a report of just the documents contained in the folder
hierarchy starting from a given folder with dataid-17493

select level,
dataid,
parentid,
substr(Lpad(' ',level-1)||name ,1,40) "Document Name"
from dtree
where subtype in (144) /* Will just print the documents only */
connect by prior dataid = parentid
start with dataid=17493
ORDER BY ROWNUM
/

LEVEL DATAID PARENTID Document Name
---------- ---------- ---------- ----------------------------------------
3 17498 17494 MPower Text File - Level 2
5 17510 17509 Population queries
5 17513 17509 SQL Best practices document
2 17495 17493 Bounce LL Batch File - Level 1
3 17502 17501 Export commands
2 17505 17493 Logminer setup

6 rows selected.

Hope this helps.

Mohsin
Oracle Technical Specialist.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion
[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, February 05, 2003 8:14 AM
To: eLink Recipient
Subject: RE Tree View of Folders under a Particular Folder

RE Tree View of Folders under a Particular Folder
Posted by eLink on 02/05/2003 08:14 AM

Message from <Stephen.Fisher@astrazeneca.com> via eLink

This is a poor solution but I found the easiest way to do this is using the
URL /livelink/livelink.exe?func=Projects.ProjectOutline&objid=<FOLDER OR
PROJECT ID>. This will work outside of a Project and will list a very nice
view of the structure. The only problem with it is, it takes a long time to
generate (experiment at a lower level folder) and you cannot filter out item
types (it lists everything, not just folders). It would be nice if Opentext
fully supported this with an interface option to do this for any folder.

If this method isn't what you want and you really want a live report then if
you are using Oracle there is something like Connect by Prior that will help
you out (lots of information in this discussion about that) but on SQL
Server, you will have to write a Stored Procedure and call it from Livelink.
We use SQL Server and I have written a stored procedure to give me a list of
folders under a given folder but it will only list folder level and the
parent ID so you have to trace through it to find the real hierarchy still.
Also I don't call it from Livelink due to the limited scope of its use. I
only use it to extract all DataID of folders in a given branch of a tree so
I can then analyze that data further (Who assigned permissions to
individuals rather then groups, what folders have delete rights and also a
lot of Children in them, how name empty folders are there in a given
division etc.)

I hope this helps.
________________________________________
Stephen Fisher
Knowledge Management Systems Specialist
AstraZeneca Canada Inc.
________________________________________

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion
[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: February 5, 2003 6:01 AM
To: eLink Recipient
Subject: Tree View of Folders under a Particular Folder

Tree View of Folders under a Particular Folder
Posted by PremOilAdmin on 02/05/2003 05:55 AM

I was wondering if anyone can help me in creating a livereport that will
display a tree view of the folder structure under a particular folder in
Livelink..
Any help would be v. much appreciated.

Thanks,
Amina.

[To reply to this thread, use your normal e-mail reply function.]

============================================================

Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&
objAction=view

Livelink Server:
https://knowledge.opentext.com/knowledge/livelink.exe

[To reply to this thread, use your normal e-mail reply function.]

============================================================

Topic: Tree View of Folders under a Particular Folder
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2961591&
objAction=view

Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&
objAction=view

Livelink Server:
https://knowledge.opentext.com/knowledge/livelink.exe

eLink User

Message from Mohsin Jessa via eLinkHi Marie:Ahah...That's why I said "may work".No, I have never tried it from LiveReport, but I'd guess that replacing the"space" with an "*" as the indenting char MAY work.Mohsin-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, February 05, 2003 2:28 PMTo: eLink RecipientSubject: Re Tree View of Folders under a Particular Folder - strippingspaces

Anthony_Murdock

Thanks to all who replied for your help. CheersAmina