SQL calculation for Workflow Milestone late?

Srini_Venkataramani

I am writing a webreport and some of the information that it returns is similar to the Workflow status page.what are the calculations that Livelink internally makes, to display the Workflow status? I am using the following: (part of TSQL query)case when w.work_status = 1 then 'Suspended' when (getdate() > w.work_datedue_max) then 'Workflow Late'when (getdate() > t.subworktask_datemilestone) then 'Milestone late'when (getdate() > t.subworktask_datedue_max) then 'Step Late'when w.work_status = 2 then 'OK'But the SQL returns the status for workflow that are actually OK as 'Milestone late' incorrectly. I guess that is because the "WSubworktask.subworktask_datemilestone" field holds the value of the last milestone "completed" and not the due date for the next milestone. HOW DOES LL calculate the due date for the next milestone? Is there a way we can do the same? Thanks in advance for any help.Srini

Greg_Petti

Message from Greg Petti via eLinkHi,You may not be aware, but WebReports also supports the ability to interpretthe status codes.Assuming that your LiveReport is returning the column work_status, thefollowing WebReport tag would convert the status value to the correct text:[LL_REPTAG=WORK_STATUS STATUS:WORK /]Just to explain this, if you used only the tag: [LL_REPTAG=WORK_STATUS /] Then you would only see the numeric status value. By adding the STATUS"subtag" you are asking WebReports to decode the numeric value. Theparameter :WORK specifies that this is a status code from the wWork table.If you were returning a numeric status from the wsubwork table you coulduse: STATUS:SUBWORK. This subtag also supports: STATUS:SUBWORKTASK,STATUS:WORKAUDIT, and STATUS:TASK. A list of these subtags (and all of the tags supported) is provided in theonline help for WebReports under Tag Guide. Subtags are in the third sectionof this guide and if you double click on any item a full description isrevealed. Cheers Greg PettiOffice: +1 403 685 9126Cell : +1 403 608 7392 -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: January 27, 2006 8:24 PMTo: eLink RecipientSubject: SQL calculation for Workflow Milestone late?SQL calculation for Workflow Milestone late?Posted by Venkataramani, Srini on 01/27/2006 10:23 PMI am writing a webreport and some of the information that it returns issimilar to the Workflow status page.what are the calculations that Livelink internally makes, to display theWorkflow status? I am using the following: (part of TSQL query)case when w.work_status = 1 then 'Suspended' when (getdate() > w.work_datedue_max) then 'Workflow Late'when (getdate() > t.subworktask_datemilestone) then 'Milestone late'when (getdate() > t.subworktask_datedue_max) then 'Step Late'when w.work_status = 2 then 'OK'But the SQL returns the status for workflow that are actually OK as'Milestone late' incorrectly. I guess that is because the "WSubworktask.subworktask_datemilestone" field holds the value of the lastmilestone "completed" and not the due date for the next milestone. HOW DOES LL calculate the due date for the next milestone? Is there a way wecan do the same? Thanks in advance for any help.Srini[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.