Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

statistics with request hql

hana jenhani
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
No matter how many women are assigned to the project, a pregnancy takes nine months. Much longer than this tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!