Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- software:dashboard:analyses:activity_analyses [2014/12/16 16:31]
127.0.0.1 Externe Bearbeitung
+++ software:dashboard:analyses:activity_analyses [2015/10/05 16:13]
martin.oehm [Durchschnittliche, minimale und maximale Durchlaufszeit aller Aktivitäten einer bestimmten Prozessdefinition (in hh:mm:ss)]
@@ Zeile 102: / Zeile 102: @@
 FROM
-(SELECT activity.name AS name, definitionname as defName,
+(SELECT activity.name AS name, definitionname AS defName,
 FLOOR(MIN((unix_timestamp(activity.END) - unix_timestamp(activity.START)))) AS minSekunden,
 FLOOR(MIN((unix_timestamp(activity.END) - unix_timestamp(activity.START)))%60) AS minSek,
@@ Zeile 114: / Zeile 114: @@
 (unix_timestamp(activity.END)-unix_timestamp(activity.START)) AS datediff
 FROM view_activity activity INNER JOIN view_instance inst ON activity.instanceId=inst.id
-WHERE activity.END IS NOT NULL AND activity.START IS NOT NULL AND activity.TYPE IN ("K","S")
+WHERE activity.END IS NOT NULL AND activity.START IS NOT NULL AND activity.TYPE IN ("K","S") AND definitionname = "Name der Prozessdefinition"
 GROUP BY activity.name
 ) AS datediffsub
 WHERE datediff > 0
-AND defName = "Name der Prozessdefinition"
+GROUP BY name
-GROUP BY name
 </code>

TIM Wiki / NEW TIM 6 Documentation