Ok I have no idea how to do this in HQL.

I have a product. The product belongs to a company. The company belongs to Sectors. How do I get all of the products in a given MarketSector?

This is my thought but I don't know how to write it



MarketSectors is a bag, it could be a map but either way it is a collection of MarketSectors.

In SQL I would have used JOINS but I tried using them and I got this error about needing a path expression.

Any thoughts?
Thanks.
dru

I believe you just use MarketSectors even when referring to a single element of the collection, so remove those brackets with question marks and try it :) I know it feels a bit unnatural, but if you imagine the SQL behind it, it makes more sense.

MarketSectors is an IList by the way.

I tried what you siad and got this error

NHibernate.QueryException: expecting 'elements' or 'indicies'

Any thoughts, I am having trouble googling it.

I have a path to the solution but I am still confused
Here is the Hibernate documentation on it

http://www.hibernate.org/hib_docs/refer ... ryhql.html

I am now just confused about elements and indicies which to use and how.

Umm, try this:

Another wrinkle is that I forgot that MarketSectors is a Many to Many type relationship so the actual HQL is more like this

sergey:
Right on!

That has me almost there. Now my problem is that I am returning an ArrayList where each entry has two entries one with the Product theother with the market sector.

Anyway I can remove the market sector?

Here is what I did. The perf on this has to horrible but I will see.



Thanks for the help. This at least has me started.