http://jenkins.wocommunity.org/job/Wonder/javadoc/er/extensions/eof/qualifiers/ERXToManyQualifier.html

On May 2, 2014, at 2:54 AM, Elizabeth Lynch <[email protected]> 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      ([email protected])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com
> 
> This email sent to [email protected]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to