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 can’t > 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
