Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Nächste Überarbeitung Beide Seiten der Revision | |||
software:dashboard:analyses:task_analyses [2014/12/16 16:31] 127.0.0.1 Externe Bearbeitung |
software:dashboard:analyses:task_analyses [2015/10/05 16:08] martin.oehm [Durchschnittliche, minimale und maximale Durchlaufszeit aller Aufgaben einer bestimmten Prozessdefinition (in hh:mm:ss)] |
||
---|---|---|---|
Zeile 116: | Zeile 116: | ||
) AS "Maximale Durchlaufzeit" | ) AS "Maximale Durchlaufzeit" | ||
FROM | FROM | ||
- | (SELECT inst.definitionname AS defName, task.name as name, | + | (SELECT inst.definitionname AS defName, task.name AS name, |
FLOOR(MIN((unix_timestamp(task.END) - unix_timestamp(task.START)))) AS minSekunden, | FLOOR(MIN((unix_timestamp(task.END) - unix_timestamp(task.START)))) AS minSekunden, | ||
FLOOR(MIN((unix_timestamp(task.END) - unix_timestamp(task.START)))%60) AS minSek, | FLOOR(MIN((unix_timestamp(task.END) - unix_timestamp(task.START)))%60) AS minSek, | ||
Zeile 128: | Zeile 128: | ||
(unix_timestamp(task.END)-unix_timestamp(task.START)) AS datediff | (unix_timestamp(task.END)-unix_timestamp(task.START)) AS datediff | ||
FROM view_task task INNER JOIN view_instance inst ON task.instanceId=inst.id | FROM view_task task INNER JOIN view_instance inst ON task.instanceId=inst.id | ||
- | WHERE task.END IS NOT NULL AND task.START IS NOT NULL | + | WHERE task.END IS NOT NULL AND task.START IS NOT NULL AND inst.definitionname = "Name der Prozessdefinition" |
GROUP BY task.name | GROUP BY task.name | ||
) AS datediffsub | ) AS datediffsub | ||
WHERE datediff > 0 | WHERE datediff > 0 | ||
- | AND defName = "Name der Prozessdefinition" | + | GROUP BY name |
- | Group by name | + | |
</code> | </code> | ||