NSFetchRequest Class Reference
| Inherits from | |
| Conforms to | |
| Framework | /System/Library/Frameworks/CoreData.framework |
| Availability | Available in OS X v10.4 and later. |
| Declared in | NSFetchRequest.h |
| Companion guides | |
Overview
An instance of NSFetchRequest describes search criteria used to retrieve data from a persistent store.
An instance collects the criteria needed to select and—optionally—order a group of managed objects, or data about records held in a persistent store. A fetch request must contain an entity description (an instance of NSEntityDescription) that specifies which entity to search. It frequently also contains:
A predicate (an instance of
NSPredicate) that specifies which properties to select by and the constraints on selection, for example “last name begins with a ‘J’”. If you don’t specify a predicate, then all instances of the specified entity are selected (subject to other constraints, seeexecuteFetchRequest:error:for full details).An array of sort descriptors (instances of
NSSortDescriptor) that specify how the returned objects should be ordered, for example by last name then by first name.
You can also specify other aspects of a fetch request—the maximum number of objects that a request should return, and which data stores the request should access. With OS X v10.5 and later you can also specify, for example, whether the fetch returns managed objects or just object IDs, and whether objects are fully populated with their properties (see resultType, includesSubentities, includesPropertyValues, and returnsObjectsAsFaults). With OS X v10.6 and later and on iOS, you can further specify, for example, what properties to fetch, the fetch offset, and whether, when the fetch is executed it matches against currently unsaved changes in the managed object context (see resultType, propertiesToFetch, fetchOffset, and includesPendingChanges). You can also fetch distinct property values, and attribute values that satisfy a given function, as illustrated in Core Data Snippets.
You use NSFetchRequest objects with the method executeFetchRequest:error:, defined by NSManagedObjectContext.
You often predefine fetch requests in a managed object model—NSManagedObjectModel provides API to retrieve a stored fetch request by name. Stored fetch requests can include placeholders for variable substitution, and so serve as templates for later completion. Fetch request templates therefore allow you to pre-define queries with variables that are substituted at runtime.
Tasks
Managing the Fetch Request’s Entity
-
+ fetchRequestWithEntityName: -
– initWithEntityName: -
– entityName -
– entity -
– setEntity: -
– includesSubentities -
– setIncludesSubentities:
Fetch Constraints
-
– predicate -
– setPredicate: -
– fetchLimit -
– setFetchLimit: -
– fetchOffset -
– setFetchOffset: -
– fetchBatchSize -
– setFetchBatchSize: -
– affectedStores -
– setAffectedStores:
Sorting
Prefetching
Managing How Results Are Returned
-
– resultType -
– setResultType: -
– includesPendingChanges -
– setIncludesPendingChanges: -
– propertiesToFetch -
– setPropertiesToFetch: -
– returnsDistinctResults -
– setReturnsDistinctResults: -
– includesPropertyValues -
– setIncludesPropertyValues: -
– shouldRefreshRefetchedObjects -
– setShouldRefreshRefetchedObjects: -
– returnsObjectsAsFaults -
– setReturnsObjectsAsFaults:
Grouping and Filtering Dictionary Results
Class Methods
fetchRequestWithEntityName:
Returns a fetch request configured with a given entity name.
Parameters
- entityName
The name of the entity to fetch.
Return Value
A fetch request configured to fetch using the entity named entityName.
Discussion
This method provides a convenient way to configure the entity for a fetch request without having to retrieve an NSEntityDescription object. When the fetch is executed, the request uses the managed object context to find the entity with the given name. The model associated with the context’s persistent store coordinator must contain an entity named entityName.
Availability
- Available in OS X v10.7 and later.
Declared In
NSFetchRequest.hInstance Methods
affectedStores
Returns an array containing the persistent stores specified for the receiver.
Return Value
An array containing the persistent stores specified for the receiver.
Availability
- Available in OS X v10.4 and later.
See Also
Declared In
NSFetchRequest.hentity
Returns the entity specified for the receiver.
Return Value
The entity specified for the receiver.
Availability
- Available in OS X v10.4 and later.
Declared In
NSFetchRequest.hentityName
Returns the name of the entity the request is configured to fetch.
Return Value
The name of the entity the request is configured to fetch.
Availability
- Available in OS X v10.7 and later.
Declared In
NSFetchRequest.hfetchBatchSize
Returns the batch size of the receiver.
Return Value
The batch size of the receiver.
Discussion
The default value is 0. A batch size of 0 is treated as infinite, which disables the batch faulting behavior.
If you set a non-zero batch size, the collection of objects returned when the fetch is executed is broken into batches. When the fetch is executed, the entire request is evaluated and the identities of all matching objects recorded, but no more than batchSize objects’ data will be fetched from the persistent store at a time. The array returned from executing the request will be a proxy object that transparently faults batches on demand. (In database terms, this is an in-memory cursor.)
You can use this feature to restrict the working set of data in your application. In combination with fetchLimit, you can create a subrange of an arbitrary result set.
Special Considerations
For purposes of thread safety, you should consider the array proxy returned when the fetch is executed as being owned by the managed object context the request is executed against, and treat it as if it were a managed object registered with that context.
Availability
- Available in OS X v10.6 and later.
See Also
Declared In
NSFetchRequest.hfetchLimit
Returns the fetch limit of the receiver.
Return Value
The fetch limit of the receiver.
Discussion
The fetch limit specifies the maximum number of objects that a request should return when executed.
Special Considerations
If you set a fetch limit, the framework makes a best effort, but does not guarantee, to improve efficiency. For every object store except the SQL store, a fetch request executed with a fetch limit in effect simply performs an unlimited fetch and throws away the unasked for rows.
Availability
- Available in OS X v10.4 and later.
See Also
Declared In
NSFetchRequest.hfetchOffset
Returns the fetch offset of the receiver.
Return Value
The fetch offset of the receiver.
Discussion
The default value is 0.
This setting allows you to specify an offset at which rows will begin being returned. Effectively, the request will skip over the specified number of matching entries. For example, given a fetch which would normally return a, b, c, d, specifying an offset of 1 will return b, c, d, and an offset of 4 will return an empty array. Offsets are ignored in nested requests such as subqueries.
This can be used to restrict the working set of data. In combination with -fetchLimit, you can create a subrange of an arbitrary result set.
Availability
- Available in OS X v10.6 and later.
See Also
Declared In
NSFetchRequest.hhavingPredicate
Returns the predicate used to filter rows being returned by a query containing a GROUP BY.
Return Value
The predicate used to filter rows being returned by a query containing a GROUP BY.
Discussion
For a full discussion, see setHavingPredicate:. For a discussion of GROUP BY, see setPropertiesToGroupBy:.
Availability
- Available in OS X v10.7 and later.
Declared In
NSFetchRequest.hincludesPendingChanges
Returns a Boolean value that indicates whether, when the fetch is executed it matches against currently unsaved changes in the managed object context.
Return Value
YES if, when the fetch is executed it will match against currently unsaved changes in the managed object context, otherwise NO.
Discussion
For a full discussion, see includesPendingChanges.
Availability
- Available in OS X v10.6 and later.
See Also
Declared In
NSFetchRequest.hincludesPropertyValues
Returns a Boolean value that indicates whether, when the fetch is executed, property data is obtained from the persistent store.
Return Value
YES if, when the fetch is executed, property data is obtained from the persistent store, otherwise NO.
Discussion
The default value is YES.
You can set includesPropertyValues to NO to reduce memory overhead by avoiding creation of objects to represent the property values. You should typically only do so, however, if you are sure that either you will not need the actual property data or you already have the information in the row cache, otherwise you will incur multiple trips to the database.
During a normal fetch (includesPropertyValues is YES), Core Data fetches the object ID and property data for the matching records, fills the row cache with the information, and returns managed object as faults (see returnsObjectsAsFaults). These faults are managed objects, but all of their property data still resides in the row cache until the fault is fired. When the fault is fired, Core Data retrieves the data from the row cache—there is no need to go back to the database.
If includesPropertyValues is NO, then Core Data fetches only the object ID information for the matching records—it does not populate the row cache. Core Data still returns managed objects since it only needs managed object IDs to create faults. However, if you subsequently fire the fault, Core Data looks in the (empty) row cache, doesn't find any data, and then goes back to the store a second time for the data.
Availability
- Available in OS X v10.5 and later.
See Also
Declared In
NSFetchRequest.hincludesSubentities
Returns a Boolean value that indicates whether the receiver includes subentities in the results.
Return Value
YES if the request will include all subentities of the entity for the request, otherwise NO.
Discussion
The default is YES.
Availability
- Available in OS X v10.5 and later.
See Also
Declared In
NSFetchRequest.hinitWithEntityName:
Initializes a fetch request configured with a given entity name
Parameters
- entityName
The name of the entity to fetch.
Return Value
A fetch request configured to fetch using the entity named entityName.
Discussion
This method provides a convenient way to configure the entity for a fetch request without having to retrieve an NSEntityDescription object. When the fetch is executed, the request uses the managed object context to find the entity with the given name. The model associated with the context’s persistent store coordinator must contain an entity named entityName.
Availability
- Available in OS X v10.7 and later.
Declared In
NSFetchRequest.hpredicate
Returns the predicate of the receiver.
Return Value
The predicate of the receiver.
Discussion
The predicate is used to constrain the selection of objects the receiver is to fetch. For more about predicates, see Predicate Programming Guide.
If the predicate is empty—for example, if it is an AND predicate whose array of elements contains no predicates—the receiver has its predicate set to nil. For more about predicates, see Predicate Programming Guide.
Availability
- Available in OS X v10.4 and later.
See Also
Declared In
NSFetchRequest.hpropertiesToFetch
Returns an array of NSPropertyDescription objects that specify which properties should be returned by the fetch.
Return Value
An array of NSPropertyDescription objects that specify which properties should be returned by the fetch.
Discussion
For a full discussion, see setPropertiesToFetch:.
Availability
- Available in OS X v10.6 and later.
Declared In
NSFetchRequest.hpropertiesToGroupBy
Returns an array of objects that indicate how data should be grouped before a select statement is run in an SQL database.
Return Value
An array of NSPropertyDescription or NSExpressionDescription objects, or keypath strings that indicate how data should be grouped before a select statement is run in an SQL database.
Discussion
For a full description see setPropertiesToGroupBy:.
Availability
- Available in OS X v10.7 and later.
Declared In
NSFetchRequest.hrelationshipKeyPathsForPrefetching
Returns the array of relationship key paths to prefetch along with the entity for the request.
Return Value
The array of relationship key paths to prefetch along with the entity for the request.
Discussion
The default value is an empty array (no prefetching).
Prefetching allows Core Data to obtain related objects in a single fetch (per entity), rather than incurring subsequent access to the store for each individual record as their faults are tripped. For example, given an Employee entity with a relationship to a Department entity, if you fetch all the employees then for each print out their name and the name of the department to which they belong, it may be that a fault has to be fired for each individual Department object (for more details, see “Core Data Performance” in Core Data Programming Guide). This can represent a significant overhead. You could avoid this by prefetching the department relationship in the Employee fetch, as illustrated in the following example:
NSManagedObjectContext *context = ...; |
NSEntityDescription *employeeEntity = [NSEntityDescription |
entityForName:@"Employee" inManagedObjectContext:context]; |
NSFetchRequest *request = [[NSFetchRequest alloc] init]; |
[request setEntity:employeeEntity]; |
[request setRelationshipKeyPathsForPrefetching: |
[NSArray arrayWithObject:@"department"]]; |
Availability
- Available in OS X v10.5 and later.
Declared In
NSFetchRequest.hresultType
Returns the result type of the receiver.
Return Value
The result type of the receiver.
Discussion
The default value is NSManagedObjectResultType.
You use setResultType: to set the instance type of objects returned from executing the request—for possible values, see “NSFetchRequestResultType.” If you set the value to NSManagedObjectIDResultType, this will demote any sort orderings to “best efforts” hints if you do not include the property values in the request.
Special Considerations
See also setIncludesPendingChanges: for a discussion the interaction of result type with whether pending changes are taken into account.
Availability
- Available in OS X v10.5 and later.
Declared In
NSFetchRequest.hreturnsDistinctResults
Returns a Boolean value that indicates whether the fetch request returns only distinct values for the fields specified by propertiesToFetch.
Return Value
YES if, when the fetch is executed, it returns only distinct values for the fields specified by propertiesToFetch, otherwise NO.
Discussion
The default value is NO.
Special Considerations
This value is only used if a value has been set for propertiesToFetch.
Availability
- Available in OS X v10.6 and later.
Declared In
NSFetchRequest.hreturnsObjectsAsFaults
Returns a Boolean value that indicates whether the objects resulting from a fetch using the receiver are faults.
Return Value
YES if the objects resulting from a fetch using the receiver are faults, otherwise NO.
Discussion
The default value is YES. This setting is not used if the result type (see resultType) is NSManagedObjectIDResultType, as object IDs do not have property values. You can set returnsObjectsAsFaults to NO to gain a performance benefit if you know you will need to access the property values from the returned objects.
By default, when you execute a fetch returnsObjectsAsFaults is YES; Core Data fetches the object data for the matching records, fills the row cache with the information, and returns managed object as faults. These faults are managed objects, but all of their property data resides in the row cache until the fault is fired. When the fault is fired, Core Data retrieves the data from the row cache. Although the overhead for this operation is small, for large datasets it may become non-trivial. If you need to access the property values from the returned objects (for example, if you iterate over all the objects to calculate the average value of a particular attribute), then it is more efficient to set returnsObjectsAsFaults to NO to avoid the additional overhead.
Availability
- Available in OS X v10.5 and later.
See Also
Declared In
NSFetchRequest.hsetAffectedStores:
Sets the array of persistent stores that will be searched by the receiver.
Parameters
- stores
An array containing identifiers for the stores to be searched when the receiver is executed.
Availability
- Available in OS X v10.4 and later.
See Also
Declared In
NSFetchRequest.hsetEntity:
Sets the entity of the receiver.
Parameters
- entity
The entity of the receiver.
Availability
- Available in OS X v10.4 and later.
Declared In
NSFetchRequest.hsetFetchBatchSize:
Sets the batch size for the receiver.
Parameters
- bsize
The batch size of the receiver.
A batch size of
0is treated as infinite, which disables the batch faulting behavior.
Discussion
For a full discussion, see fetchBatchSize.
Availability
- Available in OS X v10.6 and later.
See Also
Declared In
NSFetchRequest.hsetFetchLimit:
Sets the fetch limit of the receiver.
Parameters
- limit
The fetch limit of the receiver.
0specifies no fetch limit.
Discussion
For a full discussion, see fetchLimit.
Availability
- Available in OS X v10.4 and later.
See Also
Declared In
NSFetchRequest.hsetFetchOffset:
Sets the fetch offset of the receiver.
Parameters
- limit
The fetch offset of the receiver.
Discussion
For a full discussion, see fetchOffset.
Availability
- Available in OS X v10.6 and later.
See Also
Declared In
NSFetchRequest.hsetHavingPredicate:
Sets the predicate to use to filter rows being returned by a query containing a GROUP BY.
Parameters
- predicate
The predicate to use to filter rows being returned by a query containing a GROUP BY.
Discussion
If a having predicate is supplied, it will be run after the GROUP BY. Specifying a HAVING predicate requires that a GROUP BY also be specified. For a discussion of GROUP BY, see setPropertiesToGroupBy:.
Availability
- Available in OS X v10.7 and later.
Declared In
NSFetchRequest.hsetIncludesPendingChanges:
Sets if, when the fetch is executed, it matches against currently unsaved changes in the managed object context.
Parameters
- yesNo
If
YES, when the fetch is executed it will match against currently unsaved changes in the managed object context.
Discussion
The default value is YES.
If the value is NO, the fetch request skips checking unsaved changes and only returns objects that matched the predicate in the persistent store.
Special Considerations
A value of YES is not supported in conjunction with the result type NSDictionaryResultType, including calculation of aggregate results (such as max and min). For dictionaries, the array returned from the fetch reflects the current state in the persistent store, and does not take into account any pending changes, insertions, or deletions in the context.
If you need to take pending changes into account for some simple aggregations like max and min, you can instead use a normal fetch request, sorted on the attribute you want, with a fetch limit of 1.
Availability
- Available in OS X v10.6 and later.
See Also
Declared In
NSFetchRequest.hsetIncludesPropertyValues:
Sets if, when the fetch is executed, property data is obtained from the persistent store.
Parameters
- yesNo
If
NO, the request will not obtain property information, but only information to identify each object (used to create managed object IDs).
Discussion
For a full discussion, see includesPropertyValues.
Availability
- Available in OS X v10.5 and later.
See Also
Declared In
NSFetchRequest.hsetIncludesSubentities:
Sets whether the receiver includes subentities.
Parameters
- yesNo
If
NO, the receiver will fetch objects of exactly the entity type of the request; ifYES, the receiver will include all subentities of the entity for the request (if any).
Availability
- Available in OS X v10.5 and later.
See Also
Declared In
NSFetchRequest.hsetPredicate:
Sets the predicate of the receiver.
Parameters
- predicate
The predicate for the receiver.
Availability
- Available in OS X v10.4 and later.
See Also
Declared In
NSFetchRequest.hsetPropertiesToFetch:
Specifies which properties should be returned by the fetch.
Parameters
- values
An array of
NSPropertyDescriptionobjects that specify which properties should be returned by the fetch.
Discussion
The property descriptions may represent attributes, to-one relationships, or expressions. The name of an attribute or relationship description must match the name of a description on the fetch request’s entity.
Special Considerations
You must set the entity for the fetch request before setting this value, otherwise NSFetchRequest throws an NSInvalidArgumentException exception.
This value is only used if resultType is set to NSDictionaryResultType.
Availability
- Available in OS X v10.6 and later.
Declared In
NSFetchRequest.hsetPropertiesToGroupBy:
Sets array of objects that indicate how data should be grouped before a select statement is run in an SQL database.
Parameters
- array
An array of
NSPropertyDescriptionorNSExpressionDescriptionobjects, or keypath strings that indicate how data should be grouped before a select statement is run in an SQL database.
Discussion
If you use this setting, then you must set the resultType to NSDictionaryResultType, and the SELECT values must be literals, aggregates, or columns specified in the GROUP BY. Aggregates will operate on the groups specified in the GROUP BY rather than the whole table. If you set properties to group by, you can also set a having predicate—see setHavingPredicate:.
Availability
- Available in OS X v10.7 and later.
Declared In
NSFetchRequest.hsetRelationshipKeyPathsForPrefetching:
Sets an array of relationship key paths to prefetch along with the entity for the request.
Parameters
- keys
An array of relationship key-path strings in
NSKeyValueCodingnotation (as you would normally use withvalueForKeyPath:).
Discussion
For a full discussion, see relationshipKeyPathsForPrefetching.
Availability
- Available in OS X v10.5 and later.
See Also
Declared In
NSFetchRequest.hsetResultType:
Sets the result type of the receiver.
Parameters
- type
The result type of the receiver.
Discussion
For further discussion, see resultType.
Availability
- Available in OS X v10.5 and later.
See Also
Declared In
NSFetchRequest.hsetReturnsDistinctResults:
Sets whether the request should return only distinct values for the fields specified by propertiesToFetch.
Parameters
- values
If
YES, the request returns only distinct values for the fields specified bypropertiesToFetch.
Discussion
For a full discussion, see returnsDistinctResults.
Special Considerations
This value is only used if a value has been set for propertiesToFetch.
Availability
- Available in OS X v10.6 and later.
Declared In
NSFetchRequest.hsetReturnsObjectsAsFaults:
Sets whether the objects resulting from a fetch request are faults.
Parameters
- yesNo
If
NO, the objects returned from the fetch are pre-populated with their property values (making them fully-faulted objects, which will immediately returnNOif sent theisFaultmessage). IfYES, the objects returned from the fetch are not pre-populated.
Discussion
For a full discussion, see returnsObjectsAsFaults.
Availability
- Available in OS X v10.5 and later.
See Also
Declared In
NSFetchRequest.hsetShouldRefreshRefetchedObjects:
Sets whether the fetch request should cause property values of fetched objects to be updated with the current values in the persistent store.
Parameters
- flag
YESif the fetch request should cause property values of fetched objects to be updated with the current values in the persistent store, otherwiseNO.
Discussion
By default, when you fetch objects they maintain their current property values, even if the values in the persistent store have changed. By invoking this method with the parameter YES, when the fetch is executed the property values of fetched objects to be updated with the current values in the persistent store. This provides more convenient way to ensure managed object property values are consistent with the store than by using refreshObject:mergeChanges: (NSManagedObjetContext) for multiple objects in turn.
Availability
- Available in OS X v10.7 and later.
See Also
Declared In
NSFetchRequest.hsetSortDescriptors:
Sets the array of sort descriptors of the receiver.
Parameters
- sortDescriptors
The array of sort descriptors of the receiver.
nilspecifies no sort descriptors.
Availability
- Available in OS X v10.4 and later.
See Also
Declared In
NSFetchRequest.hshouldRefreshRefetchedObjects
Returns a Boolean value that indicates whether the property values of fetched objects will be updated with the current values in the persistent store.
Return Value
YES if the property values of fetched objects will be updated with the current values in the persistent store, otherwise NO.
Discussion
For a full discussion, see setShouldRefreshRefetchedObjects:.
Availability
- Available in OS X v10.7 and later.
See Also
Declared In
NSFetchRequest.hsortDescriptors
Returns the sort descriptors of the receiver.
Return Value
The sort descriptors of the receiver.
Discussion
The sort descriptors specify how the objects returned when the fetch request is issued should be ordered—for example by last name then by first name. The sort descriptors are applied in the order in which they appear in the sortDescriptors array (serially in lowest-array-index-first order).
Availability
- Available in OS X v10.4 and later.
See Also
Declared In
NSFetchRequest.hConstants
NSFetchRequestResultType
These constants specify the possible result types a fetch request can return.
enum {
NSManagedObjectResultType = 0x00,
NSManagedObjectIDResultType = 0x01,
NSDictionaryResultType = 0x02
NSCountResultType = 0x04
};
typedef NSUInteger NSFetchRequestResultType;
Constants
NSManagedObjectResultTypeSpecifies that the request returns managed objects.
Available in OS X v10.5 and later.
Declared in
NSFetchRequest.h.NSManagedObjectIDResultTypeSpecifies that the request returns managed object IDs.
Available in OS X v10.5 and later.
Declared in
NSFetchRequest.h.NSDictionaryResultTypeSpecifies that the request returns dictionaries.
See also
includesPendingChangesandsetPropertiesToFetch:.Available in OS X v10.6 and later.
Declared in
NSFetchRequest.h.NSCountResultTypeSpecifies that the request returns the count of the objects that match the request.
Available in OS X v10.7 and later.
Declared in
NSFetchRequest.h.
Discussion
These constants are used by resultType.
© 2011 Apple Inc. All Rights Reserved. (Last updated: 2011-10-12)