• Post Reply Bookmark Topic Watch Topic
  • New Topic

statistics with request hql  RSS feed

 
hana jenhani
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi i WOULD LIKE to do a request to recuperate a list of number of tickets from the database by status(i have an entity ticket that has an attribut status (type String) ,this status can has different values('invalid'-'resolved'-'closed'-'new') i has made 4 request for every type and it works but i would like to have all the number of each type of status in one list
i has tried to work with case when but it doesn't work

please help
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!