• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: CoreData: Using to-may relationships in fetch request predicates
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: CoreData: Using to-may relationships in fetch request predicates


  • Subject: Re: CoreData: Using to-may relationships in fetch request predicates
  • From: Frank Illenberger <email@hidden>
  • Date: Fri, 21 Aug 2009 17:31:05 +0200

"ANY (employees.salary < %@ AND employees.dateOfBirth > %@)"

But it doesn't. Does anybody know if there is a way to use the ANY statement with more than one condition?

Are you using the sqlite store type? "ANY" can't be used in a compound predicate (AND) with the sqlite store type.

Yes, I am using an sqlite store, but I tried it with the other store types and it did not work either. What would a working predicate look like for other store types?


Solution: Use another store type (probably not an appealing option) or bring in the ANY side, then filter the employees.dateOfBirth in memory.
Sadly, in-memory filtering is not an option for it has to happen in a single fetch.

_______________________________________________

Cocoa-dev mailing list (email@hidden)

Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com

Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


  • Follow-Ups:
    • Re: CoreData: Using to-may relationships in fetch request predicates
      • From: "I. Savant" <email@hidden>
References: 
 >CoreData: Using to-may relationships in fetch request predicates (From: Frank Illenberger <email@hidden>)
 >Re: CoreData: Using to-may relationships in fetch request predicates (From: "I. Savant" <email@hidden>)

  • Prev by Date: Re: CoreData: Using to-may relationships in fetch request predicates
  • Next by Date: Re: Toll-free bridging, say for NSDictionary and CFDictionary.
  • Previous by thread: Re: CoreData: Using to-may relationships in fetch request predicates
  • Next by thread: Re: CoreData: Using to-may relationships in fetch request predicates
  • Index(es):
    • Date
    • Thread