is there a proper way to fetch across a to-many and not overkill the database?

if I wanted to return a list of recently used venues that the user has 
associated with posts they have authored, I'd want a distinct return of venues, 
each having a post->author being the user, but this query like this would just 
churn on the database wouldn't it?

I didn't see a "distinct" wonder fetch property either, don't I have to use 
something to ensure the list is returned without duplicates?

                EOQualifier qual = Venue.POSTS.dot(Post.AUTHOR_KEY).eq(user());
                ERXRestFetchSpecification<Venue> fetchSpec = new 
ERXRestFetchSpecification<Venue>(Venue.ENTITY_NAME, qual, null, queryFilter(), 
Venue.CREATED.descs(), 25);

what's the best practice on that kind of fetch?



 _______________________________________________
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