Fetch spec capabilities

2014-05-02 Thread Elizabeth Lynch
I've got a query which could be dealt with by building up qualifiers, but I'd prefer to use the model-based fetch spec. As background: I have three tables: Image, Category and CategoryImage. Image: id name 1 Fred 2 Joan CategoryImage imageId categoryId

Re: Fetch spec capabilities

2014-05-02 Thread Alexander Spohr
You could do it using GROUP BY HAVING COUNT with count being the number of categories. I implemented a EOGroupByQualifier some years ago. I don’t think it made it into Wonder. Am 02.05.2014 um 11:54 schrieb Elizabeth Lynch l...@plsys.co.uk: I've got a query which could be dealt with by

Re: Fetch spec capabilities

2014-05-02 Thread Ramsey Gurley
http://jenkins.wocommunity.org/job/Wonder/javadoc/er/extensions/eof/qualifiers/ERXToManyQualifier.html On May 2, 2014, at 2:54 AM, Elizabeth Lynch l...@plsys.co.uk wrote: I've got a query which could be dealt with by building up qualifiers, but I'd prefer to use the model-based fetch spec.

Re: Fetch spec capabilities

2014-05-02 Thread Elizabeth Lynch
Hi Ramsey Thanks very much for pointing me to that: the query is now working fine. Liz On 2 May 2014, at 16:45, Ramsey Gurley rgur...@smarthealth.com wrote: http://jenkins.wocommunity.org/job/Wonder/javadoc/er/extensions/eof/qualifiers/ERXToManyQualifier.html On May 2, 2014, at 2:54 AM,