Hibernate Community • View topic - EJB-QL for testing for existence in a collection?

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

EJB-QL for testing for existence in a collection?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

sbalmos

Post subject: EJB-QL for testing for existence in a collection?

Posted: Wed Jun 21, 2006 12:13 pm

Newbie

Joined: Mon Sep 05, 2005 10:52 pm
Posts: 6

Hi all,

I'm trying to translate a query from Criteria-based to EJB-QL / HQL based. What I have is an entity named PlotMessage, with an author property, and a jointAuthors List-type collection property.

I need to select all PlotMessages where the author is equal to the author object I pass in, or the author object I pass in is a member of the jointAuthors collection. I'm trying to figure out if this is what the HQL elements() function is useful for.

What I have so far is the following:

select pm from PlotMessage pm where pm.author = :author or :author in elements(pm.jointAuthors)

Is this the appropriate query? Is there something in EJB-QL that doesn't use the elements() function, since it's Hibernate-specific?

Thanks!

--Scott

Top

alesj

Post subject:

Posted: Mon Jun 26, 2006 3:47 am

Expert

Joined: Sat Oct 25, 2003 8:49 am
Posts: 490
Location: Vrhnika, Slovenia

What about just plain IN?

Code:

select pm from PlotMessage pm, Author a where a = :author and (pm.author = a or IN (pm.jointAuthors) a)

Top

Page 1 of 1

[ 2 posts ]

Board index » Projects » Search, Validator, Shards

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