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, 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. >> >> As background: I have three tables: Image, Category and CategoryImage. >> >> Image: >> id name >> >> 1 Fred >> 2 Joan >> >> CategoryImage >> imageId categoryId >> >> 1 10 >> 1 20 >> 1 30 >> 2 15 >> 2 20 >> 2 30 >> 3 10 >> >> Category >> id title >> >> 10 Hiking >> 15 Walking >> 20 Family >> 30 Older >> >> >> The only value being passed into the query is the category title. >> >> I want to return the image id for images which are in ALL the categories I'm >> interested in - i.e., if the user selected 'Hiking', 'Family' and 'Older' >> then I want to see only image 1. If the user selected 'Walking' and 'Older' >> I'd see only image 2. >> >> Can this be done in the model-based fetch-spec rather than having to build >> up qualifiers? >> >> >> Liz >> >> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com >> >> This email sent to rgur...@smarthealth.com >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
