Can I pass a query that contains a CASE expression?

[mbmorgan]

In Jaspersoft Studio Professional...

My query looks like this:

select count(field1),
CASE field2
WHEN '...' THEN '...'
...ELSE 'Other'
END as field2
from table
where ...

group by field2

This query works fine when I run it in the actual database client, but when I copy it over to the query dialog box in Jasper and hit "read fields" I get an error:

"Error converting SQL statement into byte array..."

 

What am I doing wrong?

 

Thanks, M.B.Morgan

 

[ybablyuk]

Hello, I think problem in "group by field2" part. 

Can you please run you sql in any sql client, I think you will have error.

[mbmorgan]

I tested it in the database client first; there was no error.

[gudrun.hannesardottir]

Hi, just curious :)

 

Did you figure out how to get this to work? I have the same problem.

 

Thanks