create a Compound Predicate in coreData xcode iphone

Question

HI i am working on the core data with 3 entities (Class,Students,ExamRecord) and their relations area as :

Class<------>> Students <------> ExamRecord

I created a predicate for fetching list of students for class 5th.

NSString * fmt2 = @"studentsToClass.className=%@";
NSPredicate * p2 = [NSPredicate predicateWithFormat:fmt2,@"5th",nil];

with this i am getting all students of class 5th

Now i also want to apply another filter on the Students fetched.

Fetch students whose Exam Record "result" is "Pass".result is an attribute for student in ExamResult entity

How can i make use of Compound predicate in this ?

Please correct me if i am wrong

Any help will be appreciated

Thanks

Answer 1

You can use a compound predicate:

NSPredicate *p1 = [NSPredicate predicateWithFormat:@"studentsToClass.className = %@", @"5th"];
NSPredicate *p2 = [NSPredicate predicateWithFormat:@"studentsToExamRecord.result = %@", @"Pass"];
NSPredicate *p = [NSCompoundPredicate andPredicateWithSubpredicates: @[p1, p2]];

Or you simply combine the tests with "AND":

NSPredicate *p = [NSPredicate predicateWithFormat:@"studentsToClass.className = %@ AND studentsToExamRecord.result = %@",
      @"5th", @"Pass"];

Note that the argument list of predicateWithFormat is not nil-terminated. The number of arguments is determined by the number of format specifiers in the format string.

Answer 2

First, you shouldn't really call the student - class relation studentsToClass. The name of the relation should reflect what type of object is at the other end.

E.g.

In this case the Student relation to Class should be called class because the object there is a single Class entity. The inverse relation should not be called classToStudent it should be called students because the object there is a NSSet of multiple Students.

EDIT

Just to add to this. The name of the relation should explain WHY it is there. We can see that the relation is from class to student but if you call it "classToStudent" it doesn't explain anything. Also, what if you have a second relation from class to student? What do you call that. If you call it attendees or pupils or attendingStudents etc.. it gives the relation meaning.

SOLUTION

In this example I'm going to call them how I would call them and you will see it makes it a bit easier to understand...

Anyway...

NSPredicate *classPredicate = [NSPredicate predicateWithFormat:@"class.className = %@", @"5th"];
NSPredicate *passPredicate = [NSPredicate predicateWithFormat:@"result.name = %@", @"Pass"];

NSCompoundPredicate *compoundPredicate = [NSCompoundPredicate andPredicateWithSubpredicates:@[classPredicate, passPredicate]];