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.

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 Eastern 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.