Core Data, NSPredicate and to-many key

iphone core-data nspredicate
Massimo Cafaro picture Massimo Cafaro · Jul 22, 2009 · Viewed 33.3k times · Source

I have a Core Data model in which a Task entity includes an optional to-many relationship excludedOccurrences. One of the properties of excludedOccurrences is start, which is an NSDate object. The ExcludedOccurrence entity has an inverse mandatory to-one relationship to the Task entity.

In order to fetch tasks for a specified day, I need to make sure that the specified day does not appear as the start property of any ExcludedOccurrence entity. One of the sub-predicates I am trying to use is therefore

NSPredicate *occurrenceIsNotExcludedPredicate = [NSPredicate predicateWithFormat: @"(ALL excludedOccurrences.start != %@))", today];

where today is a NSDate object for today including only the day, month and year components. All of the excluded occurrences start properties also include just the day, month and year components.

While this should fine, at least reading the documentation for Core Data and NSPredicate, I get the following error message:

Terminating app due to uncaught exception 'NSInvalidArgumentException', reason: 'Unsupported predicate

If I use the equivalent predicate

NSPredicate *occurrenceIsNotExcludedPredicate = [NSPredicate predicateWithFormat: @"!(ANY excludedOccurrences.start == %@))", today];

no exception is thrown, however the code does not work as expected: the occurrence for today, which should not be excluded, is instead excluded.

I am not sure also how to test for the case excludedOccurrences == nil: the following predicate

NSPredicate *nilPredicate = [NSPredicate predicateWithFormat: @"(excludedOccurrences == nil)"];

causes at runtime the exception

to-many key not allowed here

However, since the excludedOccurrences relationship is optional, I also need to test if it is nil.

How do I deal with this? Thank you in advance.

Answer

Ashley Clark picture Ashley Clark · Jul 28, 2009

To test for an empty relationship you should compare the count of the to-many key to zero.

[NSPredicate predicateWithFormat:@"excludedOccurrences.@count == 0"];

As for your subpredicates, be aware that you can only have one of either the ALL or ANY modifiers in your final predicate, although you can use that modifier multiple times throughout the predicate.

Not OK: ANY foo.bar = 1 AND ALL foo.baz = 2
OK: ANY foo.bar = 1 AND !(ANY foo.baz != 2)

Related questions

core data - the primary key id of a row in the database

Suppose I have a list of books stored in Core Data. I want to search for a book by it's primary key ID. I know the sqlite file created by Core Data has an ID column in each table, but …

Read More
NSPredicate that is the equivalent of SQL's LIKE

I'm looking for a way to use NSPredicate to set a LIKE condition to fetch objects. In addition to that, an OR would be useful as well. I'm trying to do something where if a user searches "James" I can …

Read More
Core Data NSPredicate checking for BOOL value

I am currently having an issue pulling all data from db whereby i.e 1 parameter is TRUE. I am using NSPredicate and below is a sample code NSManagedObjectContext *context = managedObjectContext_; if (!context) { // Handle the error. NSLog(@"ERROR CONTEXT IS NIL"); } …

Read More