R. Theuma wrote:
Hello people I am new to the mailing list so sorry if I seem too newbie. I have a rather simple problem which I am sure most of you experienced guys solved it. I need to perform a query upon a data object which contains a Collection and need to search inside this collection.
I have a data object called accomodation and one called equipment , accomodation contains a Collection equipmentList I need something like
Select a From Accomodation a Where a.equipmentList = (1 and 2 and 3) can this be done ?
Roderick,
My apologies for the late repsonse. Below is one manner in which to query the collection similar to what you've specified above:
select a from Accomodation a where a.equipmentList.id in list( 1, 2, 3 )
Bruce
--
perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
The Castor Project http://www.castor.org/
Apache Geronimo http://incubator.apache.org/projects/geronimo.html
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
