Hibernate Community • View topic - Referring to the index of an item in a list in a query

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Referring to the index of an item in a list in a query

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

jaimark

Post subject: Referring to the index of an item in a list in a query

Posted: Wed Sep 24, 2008 8:09 pm

Newbie

Joined: Wed Sep 24, 2008 7:56 pm
Posts: 2

I have a list of value types associated to an entity type. I want to write a query to that returns the item in the list at a specific index. Something like:

Code:

select value 
from Entity as entity 
       join entity.valuelist as value 
where entity.id = :id
      and value.index = 5

of course the value.index does not work, but is there someway to do the equivalent?

-Jaimark

Top

croudet

Post subject:

Posted: Thu Sep 25, 2008 11:28 am

Regular

Joined: Mon Apr 19, 2004 6:54 pm
Posts: 79

Have you tried the index() function:

Code:

select value
from Entity as entity
       join entity.valuelist as value
where entity.id = :id
      and index(value) = 5 

Christophe

Top

jaimark

Post subject:

Posted: Mon Sep 29, 2008 5:20 pm

Newbie

Joined: Wed Sep 24, 2008 7:56 pm
Posts: 2

Sweet!

That was just want I wanted. Plus the elements function.

Thanks,

-Jaimark

Top

carlolf

Post subject:

Posted: Wed Oct 01, 2008 5:09 am

Pro

Joined: Tue Jun 12, 2007 4:13 am
Posts: 209
Location: Berlin, Germany

jaimark wrote:

Sweet!
That was just want I wanted. Plus the elements function.
-Jaimark

so, why don't you rate him?

Top

Page 1 of 1

[ 4 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