Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Core Data NSPredicate fetch on entity relationship using in clause

I would like to be able to search the relationship of an entity using an IN clause. I have the following setup: enter image description here

I would like to send over an array of nicknames and find all Persons associated with those nicknames.

//array of names to find
let nameArray: [String] = ["Tom", "Tommy", "Thomas"] 

// find all Persons who have a nickname associated with that person           
let predicate = NSPredicate(format: "ANY Person.nickName in %@",nameArray)
var fetch = NSFetchRequest(entityName: "Person")
fetch.predicate = predicate
var fetchError : NSError? = nil

// executes fetch
let results = context?.executeFetchRequest(fetch, error: &fetchError)

But when I run the code, I get the following error:

'NSInvalidArgumentException', reason: 'unimplemented SQL generation for predicate : (ANY Person.nickName IN {"Tom", "Tommy", "Thomas"})'

What am I doing wrong here? If I remove the predicate search, it returns all the results ok, but as soon as I add this line in, everything breaks.

like image 382
slidmac07 Avatar asked Jan 26 '15 20:01

slidmac07


1 Answers

You should use the relationship name in your NSPredicate.
Try this:

let predicate = NSPredicate(format: "ANY personToNick.nickName in %@", nameArray)
like image 123
Para Avatar answered Nov 15 '22 06:11

Para