Combining 'AND' and 'OR' Condition in NSPredicate

Question

Back again needing more help with constructing my NSPredicates :( ``` Category { name:string subs<-->>SubCategory } SubCategory { name:string numbervalue:NSNumber } ``` I would like to know how to create a predicate with AND and OR. For example, I would like to return every Category with name == "category_name" that also has a subcategory with a numbervalue of "valueA" OR "valueB". I've tried every possible combination of predicate constructors I could come up with but I just cant get it to work. This is my best attempt so far. ``` NSPredicate *predicate=[NSPredicate predicateWithFormat@"(name== %@) AND (ANY subs.numbervalue==%@ OR ANY subs.numbervalue==%@)", @"aname", value1, value2]; ``` Edit 1 Second attempt. The filtering on the 'numbervalue' is still not working. ``` NSNumber valueA=[NSNumber numberWithInt:20]; NSNumber valueA=[NSNumber numberWithInt:90]; NSArray *arr=[NSArray arrayWithObject:valueA,valueB,nil]; predicate=[NSPredicate predicateWithFormat:@"(name==%@)AND(ANY subs.…

Accepted Answer

I'll do the following using a `SUBQUERY`.

```
[NSPredicate predicateWithFormat@"(name == %@) AND (SUBQUERY(subs, $x, $x.numbervalue == %@ or $x.numbervalue == %@).@count > 0)", @"aname", value1, value2];
```

Try it and let me know.

Another solution could be to grab the whole collection `subs` and then filter the retrieved set with a predicate to check if elements match for `value1` or `value2`.

Hope it helps.

Edit

If you follow Eimantas suggestion make to sure to create the right array:

```
NSNumber valueA = [NSNumber numberWithInt:20];
NSNumber valueB = [NSNumber numberWithInt:90];
NSArray *arr = [NSArray arrayWithObjects:valueA, valueB, nil];
```

Combining 'AND' and 'OR' Condition in NSPredicate

Solution

Problem