Understanding Synchronization Parameters

Synchronization parameters restrict the rows that are transferred from the Unwired Server cache database (CDB) to the device to match values the client provides. A synchronization parameter does not affect enterprise information system (EIS) interaction with the CDB, unless you specify the Synchronization Parameter setting for a given load parameter.

After you bind a mobile business object (MBO) to a data source, MBO attributes map to database columns. You control the amount of data synchronized (filtered) between the CDB and device application by defining synchronization parameters that map to attributes. For example, mapping a synchronization parameter to the "state" attribute, returns customer records for a particular state based on the value entered by the device application user.

Another example is an MBO named "sales_order" with a synchronization parameter mapping to the "region" attribute, and deploy the MBO to Unwired Server, executing this query from the device application:
SELECT * FROM sales_order

returns a complete copy of all sales orders in the CDB. If the application user provides a region when synchronizing, for example "Eastern", the client sees sales orders only for the Easter region.

Using a synchronization parameter to filter results may be particularly useful for MBOs that have large amounts of data that do not change frequently, making periodic bulk loads and a longer cache interval more appropriate. For example, use select * from customer to bulk-load all customers. Then design a synchronization parameter that maps to the "state" attribute. To load only California customers, the device application user passes in the "CA" parameter.