Live Report for a task List to show Tasks and Subtasks

Angela_Costakis_(BRIINC01Admin_(Delete)_2424380)

I need some help creating a Live Report for a single Task List. I should show the high level tasks and the subtasks should follow the appropriate task.Sample of Output:TASK/SUBTASK NAME ASSIGNED TO STATUS TASK Task_NameA Jane Doe In ProcessSUBTASK Subtask_Name1 Bob Jones CompletedSUBTASK Subtask_Name2 Bob Jones IssueSUBTASK Subtask_Name3 Fred Green PendingTASK Task_NameB Greg Jackson PendingSUBTASK Subtask_Name1 Jane Doe PendingSUBTASK Subtask_Name2 Bob Jones PendingAlso, when I use table DTree, the actual name of the task does not appear. How do I retrieve the task name?Thanks,Angie Costakis

Find more posts tagged with

Comments

Cynthia_Philpott

Here is a report that we use. These are tasks associated with a project with subprojects. We also have a category added to our tasks so that we can enter additional task related info such as estimated time, so you will see a join to the category tables. The name in Dtree is the task. You need to have a a function defined in your oracle table to be able to parse out the instructiions and comments. The permid that I'm use are the permids of the task list.select dataid, decode(permid,4077306, 'Manufacturing File Exchange',4077313, 'Manufacturing File Exchange PCMS Pilot',4134451, 'Manufacturing File Exchange PEPC Pilot') "Project Name", d.name "Task Name" ,u.name "Assigned to" ,decode (priority, 0,'Low',50,'Medium',100,'High') "Priority" ,decode (status, 0, 'Pending', 1, 'In Process', 2,'Issue', 3,'On Hold', -1, 'Completed', -2, 'Cancelled') "Status", to_char(dateassigned, 'mm/dd/yyyy') "Date Assigned" ,to_char(datedue, 'mm/dd/yyyy') "Date Due" ,a.valint "Est. Man Days" , ed_value(dataid, 'Instructions')"Instructions" ,ed_value(dataid, 'Comments')"Comments"from llattrdata a, dtree d, kuaf u where d.assignedto = u.id and a.id = d.dataid and subtype = 206 and a.attrid = 10 and permid in (4077306, 4077313, 4134451, 4134451) order by permid, u.nameed_value is the function in Oracle here is the code for it.I got it from the discussion listfunction ed_value(selid in number, valuekey in varchar2)-- Extract an assoc character value from DTree.ExtendedData-- This function searches for ''='' and returns -- Alex Kowalenko 2001 01 02return varchar2is edc varchar2(32000);keytag varchar2(255);vstart number(10);vend number(10);retvalue varchar2(32000);beginselect extendeddata into edc from dtree where dataid = selid;keytag := '''' || valuekey || '''=';vstart := Instr(edc,keytag);If vstart = 0 Then retvalue := null;Elsevstart := vstart + Length(keytag) + 1;vend := Instr(edc,''',''',vstart);If vend = 0 Then vend := Instr(edc,'''>',vstart); End If;If vend >= vstart Then retvalue := replace(substr(edc,vstart,vend-vstart),'\''','''');Else retvalue := null; End If;End If;return(retvalue);end;JC Strote (strote1@llnl.gov)Information Systems TeamLawrence Livermore National LabP.O. Box 808, L-437 Livermore CA 94550Phone: (925)423-0724 Fax: (925)423-0724

Marie_Lindsay_(MLindsay_(Delete)_15608)

The XMLExport function in v9 and higher allows you to take any tree of Livelink items and export them as XML. You can add a &stylesheet parameter to the call to take the exported data and transform it to HTML (or another format), using any HTML you like. Using XML export can have advantages over LiveReports, especially when you're trying to display a hierarchical tree of Livelink items (such as a task list, its tasks and subtasks).In the Technical Education department at Open Text, we use task lists to track the desired enhancements and corrections for our courses -- so I happen to have a very simple stylesheet for looking at the task list data in a different way than the standard output. It has a different format from the one you're asking for, but it could be easily modified to give you what you want by someone who knows XSL. Here it is for you to try (if you have Livelink 9). To use it, add the XSL file to Livelink somewhere, then note its Livelink ID number (for example, by holding your cursor over it). Next, visit the task list whose tasks you want to output. Finally, change the part of the URL after ?func=ll&objid=xxxx&objaction to be:?func=ll&objid=xxxx&objaction=xmlexport&transform&stylesheet=yyyywhere xxxx is the ID of the task list and yyyy is the ID of the XSL file. Hope this is useful.

Julie_Witmer_(jwitmer_-_(deleted))

Hacked one together quickly myself for a really, really big (200+ tasks, sub tasks, sub-sub tasks) task list. Have also attached it. Needs some cleaning up, but works.Put the css and xsl into the opentext\support\xsl directory (create if req'd) and the images in an images folder in the same spot. (opentext\support\xsl\images\)Call it with the "scope=sub" parameter to walk the entire path. No hrefs or anything yet - but you can add this easily.http://localhost/livelink/livelink.exe?func=ll&objId=5687&objAction=xmlexport&scope=sub&stylesheet=xsl/tree.xsl&transform