Task list reports

I am looking for some help with a task list report. Specifically, I would like to either, browse to or enter the node ID, of a specific task list and generate a list of all individual tasks, who each task it assigned to, and some date information. I have a report that allows me to select a user and produce a list of all tasks assigned to that user but have not been able to modify it to allow me to select a task list and generate a report. Any help would be greatly appreciated. We are running MS SQL 7.0SQL for selecting user is as follows:select DTree.*, KUAF.Name kuafname from DTree, KUAF where (AssignedTo=%1) and (KUAF.ID=DTree.AssignedTo) and (DTree.DateCompleted IS NULL) and %2 and %3 order by DTree.DateDueThank you.Dave Beliveau

Find more posts tagged with

Comments

Victoria_Freihofer_(rgsinc01admin_-_(deleted))

We sometimes use a report for a specific task list or group of task lists. This was written for SQL Server 2000, it looks quite a bit different in Oracle. The report pulls active tasks only, completed or cancelled tasks are selected out.select DTree.*, KUAF.Name as kuafname, (CASE DTree.status When 0 Then 'Pending' When 1 Then 'In Process' When 2 Then 'Issue' When 3 Then 'On Hold' Else 'UnKnown' End) as mystatus from DTree, KUAF where SubType=206 and KUAF.ID=DTree.Assignedto and %1 and((DTree.Status=0) or (DTree.Status=1) or (DTree.Status=2) or (DTree.Status=3)) and (DTree.OwnerID=23932) order by DTree.Priority DESC, DTree.DateDue%1 is filter permissions, format is Livereport.Field Column Titlekuafname Assigned Tomystatus StatusDateAssigned Date AssignedDateDue Date Due

eLink User

Message from Beliveau, Dave <<A HREF="mailto:Dave.Beliveau@sanmina-sci.com">Dave.Beliveau@sanmina-sci.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">RE: Report for specific task list

This seems to work fine and I should be able to make a few minor adjustments to pull additional fields.

Thank you!

Dave Beliveau
Sanmina-SCI Corporation
eBusiness - Team Connex
Salem, NH
ph. (603)896-2797
fax (603)896-2022

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion
[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, July 01, 2002 10:54 AM
To: eLink Recipient
Subject: Report for specific task list

Report for specific task list
Posted by RGSINC01Admin on 07/01/2002 10:47 AM

select DTree.*, KUAF.Name as kuafname, (CASE DTree.status When 0 Then 'Pending' When 1 Then 'In Process' When 2 Then 'Issue' When 3 Then 'On Hold' Else 'UnKnown' End) as mystatus from DTree, KUAF where SubType=206 and KUAF.ID=DTree.Assignedto and %1 and((DTree.Status=0) or (DTree.Status=1) or (DTree.Status=2) or (DTree.Status=3)) and (DTree.OwnerID=23932) order by DTree.Priority DESC, DTree.DateDue

%1 is filter permissions, format is Livereport.

Field           Column Title
kuafname        Assigned To
mystatus        Status
DateAssigned    Date Assigned
DateDue         Date Due

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

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

Topic: Task list reports
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2772015&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

Cynthia_Philpott

Here is what we developed for a generic task list from a project. We created a function (see knowledge base for info on this thats where I found out how to do it) to include the instructions. The permid is the id for the task list. We use Oracle. We have a slightly more complex report that includes task category information, since we added a category for tasks to gather more info about the task.

Jessica_Hixon

Is there a way to capture the milestone data that is applied in the task list?

Jessica