Question

OQL query COUNT CASE

0

Hey I have a OQL query whitch need to count a value based on a string. now I have the next query but it gives error. SELECT COUNT(CASE WHEN Check.Result = 'OK' THEN 1 END) as OK the error: Caused by: java.sql.SQLSyntaxErrorException: data type cast needed for parameter or null literal in statement

asked 2020-07-13

Wim Schuiteman

2 answers

Gerrit Kiefer · Answer 1 · 2020-07-14

Have you tested this query in regular SQL context if it works and if it returns what you expect of? Maybe you should think about adding a subquery to your sql request.

Martin van Dijk · Answer 2 · 2020-07-14

Correct syntax should by like:

select
case when Result = 'OK' then count(Result) end as CountResult
from ...
group by Result