Tree View of Project Files within Livelink 9.7.1

I have a query which brings back a treeview of Livelink Project Structures. Is there a similarly efficient method of running Start and Connect commands against normal folder structures? Could a comon set of attributes rolled down within a hierarchy to improve the performance of START AND CONNECT within OracleSELECT level, lpad(' ', (level -1) * 2 ) || d.name name_indent, ltrim(sys_connect_by_path(d.name, '|'), '|') name_full_path, d.name, D.DATAID, D.SUBTYPE, D.PARENTID, D.OWNERIDFROM dtree dWHERE ownerid = &&data_id -- 9533912 CONNECT BY prior dataid = parentid START WITH dataid = -&&data_idAND ownerid = &&data_idORDER SIBLINGS BY D.ORDERING;RegardsCraig Stanley

Find more posts tagged with

Comments

Evert_Kuiken_(ekuiken_-_(deleted))

Message from Kuiken, Evert <Evert.Kuiken@alliander.com> via eLink

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

Not an answer to your question, but still: is there a reason why you do not use this function:

?func=Projects.ProjectOutline&objid=<id of top folder>

You can use it on folders also.

Regards, Evert

Greg_Griffiths

Craig, There is a detailed SQL Server version at http://www.greggriffiths.org/livelink/development/database/listchildrenfullpath.html with links to a similar Oracle one which should do what you need.