Hey Drew,
You could create a VIEW that has the primary key of your item and the
avarage of the ratings - if your DB supports VIEWs.
Then just have a new EOEntity (ItemAvarageRating) on that view and
create a 1:1 relationship from item to ItemAvarageRating.
Fetch by sorting and limiting.... done.
atze
I love view-entities :)
Am 07.05.2007 um 12:20 schrieb Drew Thoeni:
I have two objects: Item and a to-many child, review.
Review has an attribute called rating.
I'm trying to use a fetchspec (which appears to be an
impossibility) that returns the top 10 reviewed items. Basically,
I'd like to sort by [EMAIL PROTECTED] and have only 10 items
returned.
Is there a way to do this in EOModeler?
If not, I can return *all* item objects, sort by
[EMAIL PROTECTED], and create an array with only the top ten
items in it. This seems like a lot of activity compared to allowing
the database to only return the top 10 items.
Thoughts?
Regards,
Drew
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/atze%
40freeport.de
This email sent to [EMAIL PROTECTED]
Freeport & Soliversum
Alexander Spohr
[EMAIL PROTECTED]
www.freeport.de
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
