nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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