Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
Workflow report
James Mernin
HII am looking for a report that lists all workflow's completion date, and who has it (what step is the workflow in). Thanks. Leo
Find more posts tagged with
Comments
James Mernin
SELECT llops.WWork.Work_WorkID, llops.WSubWork.SubWork_Title, llops.KUAF.Name AS Performer, llops.WWork.Work_DateDue_MaxFROM llops.WWork INNER JOIN llops.WSubWork ON llops.WWork.Work_WorkID = llops.WSubWork.SubWork_WorkID INNER JOIN llops.WSubWorkTask ON llops.WSubWork.SubWork_WorkID = llops.WSubWorkTask.SubWorkTask_SubWorkID INNER JOIN llops.KUAF ON llops.WSubWorkTask.SubWorkTask_PerformerID = llops.KUAF.IDWHERE (llops.WWork.Work_Status <> - 3) AND (llops.WSubWorkTask.SubWorkTask_Status = 2 OR llops.WSubWorkTask.SubWorkTask_Status = 3) AND (llops.WSubWork.SubWork_Title LIKE 'PC Request%')ORDER BY llops.WSubWork.SubWork_TitleIt displays due date, and who has the workflow next step. Status is the field to know if 2 is there, and 3 if has started. Leo.
