Hi all,

I'm suppose this is a simple question, but I couldn't find anything on the Net (maybe I was looking with the wrong search terms)...

What I want to do is create an HQL query that retuns the count of a class that has another class appearing in the Set of one if it's properties. Let me try with an example :)

Let's say I have a class "recipe" and a class "ingredient". ingredient is a normalized entity. So, recipe has a property ingredients that is a set of ingredient items.





I'd like to count the recipe items that contain a specific ingredient (passed in with ingredient id), something like:



Any help appreciated!
Best regards,
James

fire query on Ingredient table

select count(y.recipe_id) from Ingredient as y where y.id=?

Hi,
For such cases, I think, usingSQLQuery is easier and better than HQL.
session.createSQLQuery("select count(ingredient_id) from recipe_ingredient where ingredient_id = :id").setParameter("id", 23).uniqueResult() ;
It's simple.

------------------------------------------
Rate the reply if you find it helpful

@Sagi:

I cannot query the ingredient table as ingredient is normalized. My tables look like this:



@pramodkp:

I'd rather stick to HQL if possible as my whole data access strategy is built on GenericDao. Of course, if what I want to do is not possible at all in HQL I'll resolve to something else.

Many thanks for your initial replies...