Advertisement
Guest User

Untitled

a guest
Jul 25th, 2014
234
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.85 KB | None | 0 0
  1. NSSortDescriptor *sortTitle =[NSSortDescriptor sortDescriptorWithKey:@"addedTimestamp"
  2. ascending:YES];
  3. NSArray *sortDescriptors = [NSArray arrayWithObjects:sortTitle, nil];
  4. NSFetchRequest *fetchRequest = [[NSFetchRequest alloc] init];
  5. NSEntityDescription *entity = [NSEntityDescription entityForName:@"Expense"
  6. inManagedObjectContext:context];
  7.  
  8. NSPredicate *predicate;
  9. predicate =[NSPredicate predicateWithFormat:@"(addedTimestamp <= %@) AND (addedTimestamp >= %@)",currentDate, endDate];
  10. NSAttributeDescription* amtDescription = [entity.attributesByName objectForKey:@"amount"];
  11. NSRelationshipDescription* nameDesc = [entity.relationshipsByName objectForKey:@"expenseCategory"];
  12.  
  13. NSExpression *keyPathExpression = [NSExpression expressionForKeyPath: @"amount"];
  14. NSExpression *countExpression = [NSExpression expressionForFunction: @"sum:"
  15. arguments: [NSArray arrayWithObject:keyPathExpression]];
  16. NSExpressionDescription *expressionDescription = [[NSExpressionDescription alloc] init];
  17. [expressionDescription setName: @"Sum"];
  18. [expressionDescription setExpression: countExpression];
  19. [expressionDescription setExpressionResultType: NSDecimalAttributeType];
  20.  
  21. [fetchRequest setPropertiesToFetch:[NSArray arrayWithObjects:amtDescription, expressionDescription, nameDesc, nil]];
  22. [fetchRequest setPropertiesToGroupBy:[NSArray arrayWithObject:nameDesc]];
  23. [fetchRequest setResultType:NSDictionaryResultType];
  24.  
  25. [fetchRequest setEntity:entity];
  26. [fetchRequest setPredicate:predicate];
  27. [fetchRequest setSortDescriptors:sortDescriptors];
  28. [context executeFetchRequest:fetchRequest error:&error];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement