Fetch spec capabilities
Fetch spec capabilities
- Subject: Fetch spec capabilities
- From: Elizabeth Lynch <email@hidden>
- Date: Fri, 02 May 2014 10:54:00 +0100
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden