That was so trivial that i just didnt try it. I just need the distinct like keyword and everything should go fine that way.
Ill give it a try later this week. Thanks ! Sébastien PERES-LABOURDETTE De : Ralf Joachim [mailto:[EMAIL PROTECTED] Envoyé : jeudi 21 août 2008 16:35 À : [email protected] Objet : Re: [castor-user] Stuck in oql Hi Sébastien, CastorQL currently does not support all/any/exists syntax. As a workaround pass through SQL will work. Another alternative that may be possible is to query the n side and use projection. For example, if you have a entity Foo that has a collection of Bar entites use: select o.foo from Bar o where o.name like "A%" This should return you a list of Foo entities that have a Bar with name starting with A in their collection. Having said that we are working at a refactoring of the query engine to easy later addition of new features like support for collections. Regards Ralf Sébastien PERES-LABOURDETTE schrieb: Hi. I m stuck into an oql construct. I need to query a collection attribute of my from class for matching 1..n conditions on one or more member of the collection. I was thinking that all / any / exists should be useful but I cant get the right syntax for it. Sébastien PERES-LABOURDETTE -- Syscon Ingenieurbüro für Meß- und Datentechnik GmbH Ralf Joachim Raiffeisenstraße 11 72127 Kusterdingen Germany Tel. +49 7071 3690 52 Mobil: +49 173 9630135 Fax +49 7071 3690 98 Internet: www.syscon.eu E-Mail: [EMAIL PROTECTED] Sitz der Gesellschaft: D-72127 Kusterdingen Registereintrag: Amtsgericht Stuttgart, HRB 382295 Geschäftsleitung: Jens Joachim, Ralf Joachim _____ J'utilise la version gratuite de SPAMfighter pour utilisateurs privés. 87 e-mails spam ont été bloqués jusqu'à maintenant. Les utilisateurs payant n'ont pas ce message dans leurs e-mails. Essayez SPAMfighter <http://www.spamfighter.com/lfr> gratuitement maintenant!
