[EXTERNAL] Data source with all workflows with on start (cyclical)

 External content by Sébastien Anselment, March, 2026

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

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.