Count the number of completed task for each task list found for a specfic projet

Raymond_Rousseau

Hi ! I want to know what SQL Oracle statement I must to use in my LiveReport if I want to obtain how many task are completed in number and in percent for each task list in the project where the report will be.Thanks a lot to help me !Benoît Sévigny, Revenu Québec

eLink User

Message from Alex Kowalenko via eLinkTry this SQL:select tasklist.Name "Task List", ( select count(*) from DTree task where task.SubType = 206 /* task type */ and task.OwnerID = tasklist.DataID /* task list id */ ) "Total Tasks", ( select count(*) from DTree task where task.SubType = 206 /* task type */ and task.OwnerID = tasklist.DataID /* task list id */ and task.Status = -1 /* completed */ ) "Completed Tasks", 100 * ( select count(*) from DTree task where task.SubType = 206 /* task type */ and task.OwnerID = tasklist.DataID /* task list id */ and task.Status = -1 /* completed */ ) / ( select count(*) from DTree task where task.SubType = 206 /* task type */ and task.OwnerID = tasklist.DataID /* task list id */ ) "% Completed" from DTree tasklist where tasklist.OwnerID = /* project ID */ and tasklist.SubType = 204 /* task list type */-alex------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, September 11, 2002 11:02To: eLink RecipientSubject: Count the number of completed task for each task list found fora specfic projetCount the number of completed task for each task list found for a specficprojetPosted by MinRevUser1 on 09/11/2002 10:57 AMHi ! I want to know what SQL Oracle statement I must to use in my LiveReport ifI want to obtain how many task are completed in number and in percent foreach task list in the project where the report will be.Thanks a lot to help me !Benoît Sévigny, Revenu Québec[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