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
Configure Report for # of Archived Workflows
KJM_Associates_(kjmadmin_-_(deleted))
Can anyone help me configure LiveReports so I can retrieve the total number of "Archived Workflows"? Much appreciated.
Find more posts tagged with
Comments
Philip_Schneider_(x-kpmgbe011_-_(deleted))
Hello.this could be your report:SELECT COUNT(*) AS numberFROM LIVELINK.WWorkWHERE (Work_Status = '-3') I used another one to select all completed workflow instances per workflow Map (as I have many different workflows):SELECT COUNT(LIVELINK.WWork.Work_WorkID) AS number, LIVELINK.DTree.NameFROM LIVELINK.WMap INNER JOIN LIVELINK.WSubWork ON LIVELINK.WMap.Map_MapID = LIVELINK.WSubWork.SubWork_MapID INNER JOIN LIVELINK.WWork ON LIVELINK.WSubWork.SubWork_WorkID = LIVELINK.WWork.Work_WorkID INNER JOIN LIVELINK.DTree ON LIVELINK.WMap.Map_MapObjID = LIVELINK.DTree.DataIDWHERE (LIVELINK.WWork.Work_Status = '-3')GROUP BY LIVELINK.DTree.NameKind Regards, Veronika
