Signavio Process Intelligence SiGNAL WHERE Clause

[Åsa]

Hello,

Is it possible to use an aggregation function in the WHERE Clause, or how should this be solved?

I get errors on these queries :

SELECT count(case_id) AS Cases, "CustomerName" as Customer FROM THIS_PROCESS

WHERE (count(case_id)>10)

SELECT "CustomerName" as Customer, count(case_id) AS Cases FROM THIS_PROCESS

WHERE (AVG("OrderSum (EUR)")>10)

whereas this is ok:

SELECT "CustomerName" as Customer, count(case_id) AS Cases FROM THIS_PROCESS

WHERE ("OrderSum (EUR)">10)

br. Åsa

[former_member800164]

Hi Asa,

you can create a temporary table with a sub select. Please mind the "sub" at the end.

SELECT Cases, Customer

FROM (SELECT count(case_id) AS Cases, "CustomerName" as Customer FROM THIS_PROCESS) as sub

WHERE Cases > 5

Best,

Stephan

[Åsa]

So simple... 🙂

Thank you Stephan