Data Source with all Workflows with On Start (Cyclical)

In workflow’s global actions one can add automations that get executed “on start (cyclical)”. It’s hard to keep an overview of all workflows with such automations through all application groups, applications, processes and workflows. To get an overview one can create an MSSQL data query with the current database as connection and the following SQL query.

• It returns in the first column if the cycle is active or not.
• Then there are several columns containing GUID, ID and name of the associated application group, application, process and workflow.
• Next there are all columns of the excecution statistics of the cycle
• And last all columns of the cycle itself

SQL query

1
SELECT
2
CASE
3
    WHEN ras.RAS_NextLaunch IS NOT NULL THEN 1
4
    ELSE 0
5
END as isActive,
6
AGR_GUID as agrGuid, AGR_ID as agrId, AGR_Name as agrName,
7
APP_GUID as agppGuid, APP_ID as appId, APP_Name as appName,
8
DEF_GUID as processGuid, DEF_ID as processId, DEF_Name as processName,
9
wf.wf_GUID as wfGuid, wf.WF_ID as wfId, wf.WF_Name as wfName,
10
ras.*,
11
rad.*,
12
aut.AUTM_Name
13
FROM WFRecurrentActionsDefinitions rad
14
LEFT JOIN WorkFlows wf
15
  ON wf.WF_ID = rad.RAD_WFID
16
LEFT JOIN WFDefinitions process
17
  ON process.DEF_ID = wf.WF_WFDEFID
18
LEFT JOIN Automations aut
19
  ON aut.AUTM_ID = rad.RAD_AUTMID
20
LEFT JOIN WFApplications app
21
  ON app.APP_ID = process.DEF_APPID
22
LEFT JOIN WFApplicationsGroups agr
23
  ON agr.AGR_ID = app.APP_AGRID
24
LEFT JOIN WFRecurrentActionsStats ras
25
  ON ras.RAS_ID = rad.RAD_ID

Portal integration

To get this table accessible in the portal one can create a process with a data table field associated to this MSSQL data source. Go to the Workflow Designer and just delete all paths, the end step and the phases execution and end. Put this global formrule in the behavior tab of the Main Form to avoid the unsaved data popup when leaving:

Disable “unsaved data” alert when leaving a form

Create a start und presentation that loads this “Display all cycles” form.