Hibernate Community • View topic - making a LEFT JOIN on a collection filter. Is it possible?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

making a LEFT JOIN on a collection filter. Is it possible?

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

bernardsirius

Post subject: making a LEFT JOIN on a collection filter. Is it possible?

Posted: Thu Jan 20, 2005 10:59 am

Newbie

Joined: Mon Dec 27, 2004 10:23 am
Posts: 7

Hi, I'm using

hibernate 2.1.6 with mysql on windows xp pro and java 5

I have Resource entities that are linked with AccessRights entities which are associated with User and Role entities

Is it possible to filter the accessrights from the Resource based on the user id.

i.e., I'd like to do something like this:

Code:

FROM this LEFT JOIN this.users AS user WHERE path=:path AND name=:name AND (user.userId=:userId OR rights.role.roleId IN (:groupIds)) AND (rights.flags&:permission!=0)

bernard

Top

michael

Post subject:

Posted: Thu Jan 20, 2005 11:02 am

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

Did you try it?

Top

bernardsirius

Post subject:

Posted: Thu Jan 20, 2005 5:22 pm

Newbie

Joined: Mon Dec 27, 2004 10:23 am
Posts: 7

sorry for the noise... hibernate rocks!

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate 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