What are the three SQL statements being generated. That is usually where to start looking.
Chuck On 2012-05-17, at 10:17 AM, Mark Gowdy wrote: > Hi, > > I have a 'Media' entity, and a 'Category' entity. > I need to create a qualifier that queries on 2 'to-one' relationships, as > well as on a single 'to-many'. > > > These are some test qualifiers and the number of distinct results they got: > > EOQualifier q1 = > Media.PRIMARY_CATEGORY.eq(cat).or(Media.SECONDARY_CATEGORY.eq(cat)); // > result count = 16 (correct) > // > EOQualifier q2 = Media.OTHER_CATEGORIES.containsObject(cat); // result count > = 11 (correct) > // > EOQualifier q3 = > Media.PRIMARY_CATEGORY.eq(cat).or(Media.SECONDARY_CATEGORY.eq(cat)).or(Media.OTHER_CATEGORIES.containsObject(cat)); > // result count = 15 (WRONG, should be 27) > // > // Another way > EOOrQualifier q4 = new EOOrQualifier(new NSArray( new EOQualifier[] {q1,q2 } > )); // result count = 15 (WRONG) > > > In the past, I worked around the problem by doing two separate fetches and > combining the results. But I would like to do it in one. > So, any ideas how can I get 'q3' to work? > > The main reason for fixing this, is that I need to combine a few of these > with a larger AND qualifier, and some of the intermediary qualifiers are > likely to have LOTS of results. > > Regards, > > Mark > > > _______________________________________________ > 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/chill%40global-village.net > > This email sent to ch...@global-village.net -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/gvc/practical_webobjects
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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