Hibernate Community • View topic - Elements function with criteria

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Elements function with criteria

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

santon

Post subject: Elements function with criteria

Posted: Sun Sep 17, 2006 11:23 am

Newbie

Joined: Fri May 05, 2006 4:54 am
Posts: 14

Hi!

This works ok:
select elements(group.Contacts) from Group group where group.GroupId = 7

But I need to add a criteria for the elements returned. If I only want to return the contacts with firstname = "tony" I write:

select elements(group.Contacts) from Group group where 'tony' in elements(group.Contacts.FirstName) and group.GroupId = 7

This does not work and I get the exception:
expecting 'elements' or 'indices' after id

I use Nibernate 1.2

Toni

Top

Page 1 of 1

[ 1 post ]

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