Retrieving Data from an MBO

To retrieve data from a local database use the find, findAll, or findByPrimaryKey methods in the MBO class.

The following examples show how to use the find, findAll, or findByPrimaryKey methods in the MBO class to retrieve data.

+ ( <Name Prefix>_Customer*)find:(int32_t)id_ – The find method retrieves a Customer by the given ID. The parameter id_ is the surrogate key (the primary key used in the local database). The parameter is of type int32_t in this example, but could be another type based on the key type. The value "101" in this example is the surrogate key value (automatically generated from the KeyGenerator). To use this method, the client application must be able to retrieve the surrogate key.
```
SampleApp_Customer *customer = [SampleApp_Customer find:101];  
```
Note: The Eclipse IDE allows you to specify a value for "name prefix" when generating the MBO Objective-C code. When a value is specified, all the MBO entity names are prefixed with that value. When no such prefix is specified, the name prefix is by default the package name.
+ (SUPObjectList*)findAll – Call the findAll method to list all customers:
```
SUPObjectList *customers = [SampleApp_Customer findAll] ;
```
+(SUPObjectList*) findAll:(int32_t)skip take:(int32_t)take – To define more than one findAll attribute, and return a collection of objects that match the specified search criteria, use:
```
SUPObjectList *customers = [ SampleApp_Customer findAll: 100 take:5];
```

Methods Generated if Dynamic Queries are Enabled

+ (SUPObjectList*)findWithQuery:(SUPQuery*)query; – Returns a collection of objects that match the result of executing a specific query. The method takes one parameter, query which is an SUPQuery object representing the actual query to be executed.
```
SUPQuery *myquery = [SUPQuery getInstance];            
myquery.testCriteria = [SUPAttributeTest match:@"fname" :@”Erin”];
SUPObjectList* customers = [SampleApp_Customer findWithQuery: myquery]
```
+ (int32_t)countWithQuery:(SUPQuery*)query; – Returns a count of the records returned by the specific query.
```
int count = [SampleApp_Customer countWithQuery:myquery];
```