Plugin installed incorrectly. Rename plugin directory 'swiftmail.backup' to 'swiftmail'.

This translation is older than the original page and might be outdated. See what has changed.

en:software:dashboard:analyses:definition_analyses_oracle

Table of Contents

Definition-Related Analyses
- - Number of loops (>0) per definition

This page is not fully translated, yet. Please help completing the translation.
(remove this paragraph once the translation is finished)

Definition-Related Analyses

Number of loops (>0) per definition

SELECT 
defName AS Prozess, 
SUM(lCount) AS NumberOfLoops 
 FROM 
  (
    SELECT vi.definitionname AS defName, vi."name" AS instName, va."LOOPCOUNT" AS lCount, vi.id AS piId
    FROM view_instance vi, view_activity va
    WHERE va."LOOPCOUNT" IS NOT NULL 
    AND va."INSTANCEID" = vi.id
  GROUP BY vi.id, vi.definitionname, vi."name",va."LOOPCOUNT") 
  GROUP BY defName

en/software/dashboard/analyses/definition_analyses_oracle.txt · Last modified: 2021/07/01 09:52 (external edit)