Message from Anne Callanan via eLinkThis is a multi-part message in MIME format.--Boundary_(ID_x6AYVYpHM09BLMphps/Yeg)Content-type: text/plain; charset=us-asciiContent-transfer-encoding: 7bitDear AlexI wasn't very clear in my question about reporting on compound document elements so I have attached a file that shows the output I get when I run this report and the actual Compound document outline as displayed by Livelink.Thanks in anticipationAnneeLink Discussion: Livelink LiveReports Discussion wrote:> Re Taxonomy from some container 2> Posted by eLink on 05/03/2001 05:49 AM>> Message from Anne Callanan via eLink>> Dear Alex>> This report is very interesting but you make a comment that it reports Compound Documents. Do you mean just the name of the Compound Document within say a project or did you mean that you can select a Compound Document as the container to report on?>> Keep up the good work> Best regards> Anne>> eLink Discussion: Livelink LiveReports Discussion wrote:>> > Taxonomy from some container> > Posted by akowalen on 05/02/2001 05:43 PM> >> > To get a taxonomy replica starting from some container other than the enterprise root (dataid = 2000 or 2001) use the following Oracle code in a LiveReport with a Container input field. It also reports Compound documents and taxonomy within (sub)projects but does not sort elements within a container:> >> > select> > lpad(' ', 4 * (level - 1) + 1,'|...') || dree.name "name",> > DTree.DataID,> > DTree.SubType,> > DTree.GIF,> > DTree.PermID,> > DTree.Reserved,> > DTree.ReservedBy> > from> > dtree> > where> > subtype in (0,136,202)> > start with> > dataid = %1> > connect by prior dataid = abs(parentid)> >> > [To reply to this thread, use your normal e-mail reply function.]> >> > ============================================================> >> > Topic: I need an outline of the taxonomy from the Enterprise Level> >
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2499890&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>> --> Anne Callanan - a.callanan@unl.ac.uk>> Intranet Services Team>> University of North London>> Telephone: 020 7607 2789 Extension: 2389>> [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--Anne Callanan - a.callanan@unl.ac.ukIntranet Services TeamUniversity of North LondonTelephone: 020 7607 2789 Extension: 2389--Boundary_(ID_x6AYVYpHM09BLMphps/Yeg)Content-type: text/plain; charset=us-ascii; name="CompoundDocument.txt"Content-disposition: inline; filename="CompoundDocument.txt"Content-transfer-encoding: 7bitDear AlexI didn't explain myself very well in my previous reply with regard to your 'container report',so I am sending an example of:a) The output that I get from your report (I chose the project as the 'container' so this is only some of the contentsbut it is all the reference to the compound document elements)andb) A print of the actual outline as displayed by Livelinka)|... A Specific Programme Compound Document 289476 136|...|... 11 Programme Features Requirements Structures 289487 136 |...|... 09 Main Educational Aims 289485 136|...|... 10 Programme Outcomes 289486 136|...|...|... 10a Knowledge and Understanding 289501 136 |...|...|... 10d Cognitive (thinking) Skills 289502 136 |...|...|... 10g Practical Skills 289503 136|...|...|... 10j Key Skills 289504 136b)Outline for: A Specific Programme Compound Document[Compound Document] 0 A Specific Programme Compound Document [Document] 0.1 01 Awarding Institution.doc [Document] 0.2 02 Teaching Institution.doc [Document] 0.3 03 Programme accredited by.doc [Document] 0.4 04 Final Award.doc [Document] 0.5 05 Name of Pathway.doc [Document] 0.6 06 UCAS Code.doc [Document] 0.7 07 QAA Benchmarking Statements.doc [Document] 0.8 08 Date Produced.doc [Compound Document] 0.9 09 Main Educational Aims + [Document] 0.9.1 09a Scheme Main Educational Aims.doc + [Document] 0.9.2 09b Routes Pathways Main Educational aims.doc [Compound Document] 0.10 10 Programme Outcomes + [Document] 0.10.1 10 Programme Outcomes.doc + [Compound Document] 0.10.2 10a Knowledge and Understanding + [Document] 0.10.2.1 10a Knowledge and Understanding.doc + [Document] 0.10.2.2 10b Teaching Learning Strategies.doc + [Document] 0.10.2.3 10c Assessment.doc + [Compound Document] 0.10.3 10d Cognitive (thinking) Skills + [Document] 0.10.3.1 10d Cognitive.doc + [Document] 0.10.3.2 10e Teaching Learning strategies.doc + [Document] 0.10.3.3 10f Assessment.doc + [Compound Document] 0.10.4 10g Practical Skills + [Document] 0.10.4.1 10g Practical Skills.doc + [Document] 0.10.4.2 10h Teaching Learning Strategies and Methods.doc + [Document] 0.10.4.3 10i Assessment.doc + [Compound Document] 0.10.5 10j Key Skills + [Document] 0.10.5.1 10j Key skills.doc + [Document] 0.10.5.2 10k Teaching Learning Strategies and Methods.doc + [Document] 0.10.5.3 10l Assessment.doc + [Document] 0.10.6 10m Program Outcomes Formulation.doc [Compound Document] 0.11 11 Programme Features Requirements Structures + [Document] 0.11.1 11 Programme Features and Requirements.doc + [Document] 0.11.2 11a Curriculum Map BA Single Honours.doc + [Document] 0.11.3 11b Curriculum Map BA Major, Minor, Joint Honours.doc Would I be able to modify the SQL to print the names of all these elements?Thanks in AnticipationAnne--Boundary_(ID_x6AYVYpHM09BLMphps/Yeg)--
