Hibernate Community • View topic - Hql query on getting distinct children

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Hql query on getting distinct children

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

bosh

Post subject: Hql query on getting distinct children

Posted: Tue Nov 28, 2006 10:29 am

Regular

Joined: Fri Nov 04, 2005 12:37 pm
Posts: 81

asp 2.0 Nhibernate 1.2.0.Beta1

I have a Customer entity that has a many to one relationship with a Location entity.

I need a piece of HQL that returns a distinct alphabetical sorted List of Locations used by Customers.

Im having trouble getting my head around how to do this in HQL, in SQL it would be something like this:

Code:

SELECT DISTINCT LocationID
FROM         Customers
ORDER BY LocationID

How do i do this in HQL? bearing in mind i don't want a list of LocationIDs returned, i want a list of Location Objects.

Thanks

Top

bosh

Post subject:

Posted: Wed Nov 29, 2006 5:20 am

Regular

Joined: Fri Nov 04, 2005 12:37 pm
Posts: 81

Code:

<query name="Location.GetAllUsed"><![CDATA[select distinct Location from (select cus.Location from Customer cus)]]></query>

I tried this, with no joy.

Can anyone help? or is my question too dumb or something?

Top

floda

Post subject:

Posted: Wed Nov 29, 2006 5:35 am

Newbie

Joined: Mon Mar 27, 2006 10:24 am
Posts: 8
Location: Malmoe, Sweden

this should do the trick

Code:

IList _list = session.Find("select distinct cus.Location from Customer cus");

/Floda

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum