Core data Fetch request error for predicate

Question

Need

I have to find the record with rec_name is "Apple 256GB Macbook" & isActive == true.

Fetch Request

fetchRequest.predicate = NSPredicate(format: "rec_name LIKE[cd] *%@* AND rec_name LIKE[cd] *%@* AND isActive = %@","apple","macbook",true)

Error

Unable to parse the format string "rec_name LIKE[cd] *%@* AND rec_name LIKE[cd] *%@* AND isActive = %@"

Thank you,

A placeholder for a Bool is %d or %ld rather than %@ — vadian
– vadian, Commented May 15, 2017 at 6:35
Try this : let predicate = NSPredicate(format: "rec_name LIKE[cd] %@ AND rec_name LIKE[cd] %@ AND isActive = %@","apple","macbook",NSNumber(booleanLiteral: true)) — KKRocks
– KKRocks, Commented May 15, 2017 at 6:40
try this fetchRequest.predicate = NSPredicate(format: "rec_name LIKE[cd] %@ AND rec_name LIKE[cd] %@ AND isActive = %d","apple","macbook",true) — jignesh Vadadoriya
– jignesh Vadadoriya, Commented May 15, 2017 at 6:41

Nirav D · Accepted Answer · 2017-05-15 07:53:58Z

1

The problem is because of *%@* here %@ between the * is not replaced by a string argument so NSPredicate is not able to make your query LIKE *apple* and LIKE *macbook* what you need to do is make a search string with wildcards and with Like simply use %@, also as @Vadian suggested use number instead of Bool.

let searchkeyword1 = "apple"
let searchkeyword2 = "macbook"

//Make search string wildcards charaters
let searchString1 = "*\(searchkeyword1)*"
let searchString2 = "*\(searchkeyword2)*"

fetchRequest.predicate = NSPredicate(format: "rec_name LIKE[cd] %@ AND rec_name LIKE[cd] %@ AND isActive = %@", searchString1,searchString2, true as NSNumber)

Also batter option here is you can use CONTAINS and no need to use of wildcards.

fetchRequest.predicate = NSPredicate(format: "rec_name CONTAINS[cd] %@ AND rec_name CONTAINS[cd] %@ AND isActive = %@", "apple","macbook", true as NSNumber)

You can do one more thing if you want to find all record start with apple and end with macbook then you can simply use BEGINSWITH and ENDSWITH

fetchRequest.predicate = NSPredicate(format: "rec_name BEGINSWITH[cd] %@ AND rec_name ENDSWITH[cd] %@ AND isActive = %@", "apple","macbook", true as NSNumber)

edited May 15, 2017 at 7:53

answered May 15, 2017 at 7:31

Nirav D

72.6k12 gold badges168 silver badges187 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Martin R Over a year ago

Better: NSNumber(value: true) or true as NSNumber, compare stackoverflow.com/a/42933246/1187415. There is usually no reason to call the "xxxLiteral" initializers, they are required only for the compiler.

Nirav D Over a year ago

@MartinR Thanks for the suggestion, edited answer with it

KKRocks · Accepted Answer · 2017-05-15 06:47:22Z

0

Try this

fetchRequest.predicate =  NSPredicate(format: "rec_name LIKE[cd] %@ AND rec_name LIKE[cd] %@ AND isActive = %@","apple","macbook",NSNumber(booleanLiteral: true))

answered May 15, 2017 at 6:47

KKRocks

8,3321 gold badge23 silver badges87 bronze badges

Comments

Nitin Gohel · Accepted Answer · 2017-05-15 06:48:07Z

0

You need to set a predicate query like following:

fetchRequest.predicate = NSPredicate(format: "rec_name == %@ AND isActive == %@" , "Apple 256GB Macbook", NSNumber(booleanLiteral: true))

I don't think we need to use Like if you are looking for perfect match.

answered May 15, 2017 at 6:48

Nitin Gohel

49.7k18 gold badges107 silver badges144 bronze badges

Comments

jignesh Vadadoriya · Accepted Answer · 2017-05-15 06:50:33Z

0

Try this

NSPredicate(format: "rec_name == %@ AND rec_name == %@ AND isActive = %d","apple","macbook",true)

answered May 15, 2017 at 6:50

jignesh Vadadoriya

3,3143 gold badges22 silver badges30 bronze badges

Collectives™ on Stack Overflow

Core data Fetch request error for predicate

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related