我对以下数据有一个NSFetchRequest (在NSFetchedResultsController中执行):
Person (one-to-many) Encounter遇到有一个int字段"type“。在我的tableView中,我想展示:
Person A - Encounter of type 1
Person A - Encounter of type 2
Person B - Encounter of type 1也就是说,对于一个人来说,我只想要每种类型的一次相遇。有没有办法在核心数据查询中做到这一点?我可以用代码来过滤NSFetchRequest的结果,但是我不能使用NSFetchedResultsController。
编辑
这是我目前正在尝试的代码。结果是一个人的几个相同类型的相遇。
NSFetchRequest *fetchRequest = [[NSFetchRequest alloc] init];
// entity
NSEntityDescription *entity = [NSEntityDescription entityForName:@"Encounter" inManagedObjectContext:self.managedObjectContext];
[fetchRequest setEntity:entity];
// return distinct
NSDictionary *entityProperties = [entity propertiesByName];
[fetchRequest setPropertiesToFetch:[NSArray arrayWithObjects:
[entityProperties objectForKey:@"person"],
[entityProperties objectForKey:@"type"],
nil]];
[fetchRequest setReturnsDistinctResults:YES];
[fetchRequest setResultType:NSDictionaryResultType];
NSError *error;
NSArray *fetchedObjects = [self.managedObjectContext executeFetchRequest:fetchRequest error:&error];
for (NSDictionary *d in fetchedObjects) {
NSLog(@"NSDictionary = %@", d);
}
[fetchRequest release];发布于 2011-08-20 08:11:10
我假设你只想为每种类型的遭遇返回一条记录,即使一个人有多个给定类型的记录。您可以通过相应地调整NSFetchRequest来实现这一点:
[fetchRequest setReturnsDistinctValues:YES];https://stackoverflow.com/questions/7128014
复制相似问题