NSPredicate string

Question

I have a NSPredicate to use searching Core Data:

NSPredicate *predicate = [NSPredicate predicateWithFormat:@"objID == %@ AND createDate >= %@ AND createDate <= %@",self.objID, self.fromDate, self.toDate];

I want to expand this predicate to include the date range or if the "createDate" is nil. I'm not that familiar with SQL type searches.

Basiclly, I want to find all Core Data entities with objID and within the date range or nil.

if (objID == X && ((dateRange >= fromDate && dateRange <= toDate) || dateRange == nil))

How can I do it?

Did you try translating that into a predicate? – Wain Jul 30 '13 at 14:35 — Wain, Jul 30 '13 at 14:35

score 1 · Accepted Answer · edited May 23 '17 at 11:56

1

NSPredicate *predicate = [NSPredicate predicateWithFormat:@"objID == %@ AND (createDate >= %@ AND createDate <= %@ OR createDate = nil)",self.objID, self.fromDate, self.toDate];

I've just added OR createDate = nil.

Check this answer. Christopher Pickslay said, you can use "nil" or "NULL", but not "NIL".

edited May 23 '17 at 11:56

Community

1
1

answered Jul 30 '13 at 14:36

Valentin Shamardin

3,569
4
34
51

I don't need to worry about group them like in a If stmt? – Padin215 Jul 30 '13 at 14:42
1

@Log139, NSPredicate groups statements according to algebra of logic. A AND B OR C equals (A AND B) OR C – Valentin Shamardin Jul 30 '13 at 14:45
Ok, so is this predicate grouping like `(objID = X AND createDate >= X AND createDate <= X) OR createDate = nil`? – Padin215 Jul 30 '13 at 14:49
@Log139, Yes, it is. Is it ok for you? If not, just add brackets in predicate's body – Valentin Shamardin Jul 30 '13 at 14:50
ok, thanks. No, I need it like `objID == X AND ((AND createDate >= X AND createDate <= X) OR create = nil)` Do `()` work in predicates? – Padin215 Jul 30 '13 at 14:52
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/34461/discussion-between-valentin-shamardin-and-log139) – Valentin Shamardin Jul 30 '13 at 14:54

NSPredicate string

1 Answers1