Synchronization parameters restrict the rows that are transferred from the Unwired Server cache database (CDB) to the device to match values the client provides.
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.