Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
— |
software:dashboard:analyses:definition_analyses [2021/07/01 09:52] (aktuell) |
||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
+ | ======Definitionsbezogene Auswertungen====== | ||
+ | |||
+ | ==== Anzahl der Schleifen (>0) je Definition ==== | ||
+ | <code sql> | ||
+ | select lpi.defName as Prozess, sum(lpi.lCount) as Schleifendurchläufe from | ||
+ | (select inst.definitionname as defName, inst.instancename as instName, act.loopcount as lCount, inst.instanceid as instId from | ||
+ | (select name as instancename, id as instanceid, definitionname from view_instance) as inst | ||
+ | join | ||
+ | (select instanceID, name, loopcount from view_activity order by loopcount desc) as act on act.loopcount is not null and act.instanceID = inst.instanceid | ||
+ | group by inst.instanceid) as lpi group by lpi.defName | ||
+ | </code> | ||
+ | |||
+ | |||