count objects?

atomicjoe · **Posted:** Mon Aug 01, 2005 8:05 am

Hi, is there any count() function in HQL that I can use to get a count of how many objects exist in the database?

In my case I need to get a count of all objects with a certain StatusId, something like

Code:

(?)count(?) resources from Resources as resources where resources.StatusId = 2

Obviously the syntax above is not correct, does anybody know the right way to do this? I could just select all the objects and return a count of them, but this seems like a waste when all I want to do is find out how many exist.

KPixel · **Posted:** Mon Aug 01, 2005 10:18 am

Try

Code:

select count(r) from Resources r where r.StatusId = 2

Read more here:
11.5. Aggregate functions

atomicjoe · **Posted:** Mon Aug 01, 2005 3:53 pm

Thanks for the reply, that helps! :)