case ..when query in hql

Question

I have to check null against the entry.
I have address in person object, so I have tried to fetch it like below.

select new map(person.id as id,
               case when person.address is not empty 
               then person.address.city end as city) 
from Person person where person.id=:id

Does case..when work with where clause

But there is no error and result.

possible duplicate of http://stackoverflow.com/questions/456181/using-a-case-statement-in-hql-select — Pramod S. Nikam, May 12 '14 at 10:51

score 0 · Answer 1 · answered May 12 '14 at 10:59

0

try this:

select new map(person.id as id,coalesce(person.address,person.address.city )as city) from Person person

answered May 12 '14 at 10:59

renis

171
7
16

case ..when query in hql

1 Answers1