FIXME **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 ====
<code sql>
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​
</code>