Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
software:dashboard:analyses:activity_analyses [2014/12/16 16:31] 127.0.0.1 Externe Bearbeitung |
software:dashboard:analyses:activity_analyses [2021/07/01 09:52] (aktuell) |
||
---|---|---|---|
Zeile 102: | Zeile 102: | ||
FROM | 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)))) AS minSekunden, | ||
FLOOR(MIN((unix_timestamp(activity.END) - unix_timestamp(activity.START)))%60) AS minSek, | 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 | (unix_timestamp(activity.END)-unix_timestamp(activity.START)) AS datediff | ||
FROM view_activity activity INNER JOIN view_instance inst ON activity.instanceId=inst.id | 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 | GROUP BY activity.name | ||
) AS datediffsub | ) AS datediffsub | ||
WHERE datediff > 0 | WHERE datediff > 0 | ||
- | AND defName = "Name der Prozessdefinition" | + | GROUP BY name |
- | GROUP BY name | + | |
</code> | </code> | ||