Core Data: NSPredicate for many-to-many relationship. ("to-many key not allowed here")

Question

I have two entities named "Category" and "Article" which have a many to many relationship. I want to form a predicate which searches for all articles where category.name is equal to some value. I have the following:

 NSEntityDescription  *entityArticle   = [NSEntityDescription entityForName:@"Article" inManagedObjectContext:managedObjectContext];   NSSortDescriptor  *sortDescriptor   = [[NSSortDescriptor alloc] initWithKey:@"title" ascending:YES];  NSArray     *sortDescriptors  = [[NSArray alloc] initWithObjects:sortDescriptor, nil];  NSPredicate    *predicate    = [NSPredicate predicateWithFormat:@"categories.name == [cd] %@", category.name];    [request setSortDescriptors:sortDescriptors];  [request setEntity:entityArticle];  [request setPredicate:predicate];   NSMutableArray *results = [[managedObjectContext executeFetchRequest:request error:nil] mutableCopy];   if ([results count] > 0)   NSLog(@"Results found.");   else    NSLog(@"NO results found.");    [request release];  [sortDescriptor release];  [sortDescriptors release]; 

The error I receive is *** Terminating app due to uncaught exception 'NSInvalidArgumentException', reason: 'to-many key not allowed here'

Are there any options to retrieve the desired data?

Answer 1

You're trying to compare a collection (categories.name) to a scalar value (category.name). You need to either use a collection comparator (CONTAINS), or use a predicate modifier (ANY/ALL/SOME, etc).

Try using:

[NSPredicate predicateWithFormat:@"ANY categories.name =[cd] %@", category.name]; 

Or:

[NSPredicate predicateWithFormat:@"categories.name CONTAINS[cd] %@", category.name]; 

Answer 2

SWIFT SYNTAX

In case anyone happens upon this writing in swift as I did...

let predicate = NSPredicate(format: "ANY categories.name = %@", category.name!) fetchRequest.predicate = predicate 

worked for me.