Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Query problem

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

rmaragno

Post subject: Query problem

Posted: Sun Jan 08, 2012 1:11 pm

Newbie

Joined: Sat Jul 16, 2011 4:15 pm
Posts: 3

Hello,

In MySql I have this query:

Code:

SELECT 
    PREF_RESPONSAVEL,
    SUM(CASE STATUS_ATUAL WHEN 1 THEN 1 ELSE 0 END) AS Pendentes,
    SUM(CASE STATUS_ATUAL WHEN 99 THEN 1 ELSE 0 END) AS Concluidos
FROM tb_levantamentos
GROUP BY PREF_RESPONSAVEL

How can I do this query using hibernate?
Is this possible to use the API Criteria to do this query?

Thank you!

Top

rmaragno

Post subject: Re: Query problem

Posted: Tue Jan 10, 2012 12:32 pm