Configuring Data Synchronization by Filtering Attributes

Filtering by a mapped attribute does not affect the Enterprise Information System (EIS) interaction with Unwired Server. Instead it restricts the rows transferred from the Consolidated database (Cdb) to the client database to match values the client provides (or retrieved from the default value or personalization key value when the client does not provide a value).

From the Mobile Application Diagram, right-click the MBO for which you are configuring synchronization and select Show Properties View.
In the Properties view, select the Attributes tab located on the left side, then select the Attributes Mapping tab located on the top.
Unselect Hide Advanced Columns.
Select Filter by next to the attribute (or attributes) used for synchronization.
If you specify a Personalization Key, the client is not required to provide a value, but must define a personalization value for the key before successfully using the MBO.

You develop an MBO named "salesOrder" mapped to a Filter by attribute named "region", and deploy the MBO to Unwired Server. The device application executes this query:

SELECT * FROM sales_order

This query returns a complete copy of all sales orders in the Cdb. But if the developer selects the Filter by option, the client application can then provide a region parameter when it synchronizes. If the client passes a value of "Eastern," then the client sees only sales orders where the region is Eastern. In this case, the Cdb cache is not partitioned. Each time this MBO refreshes, Unwired Server re-retrieves all the sales orders and applies the differential calculations from the rows returned against all the sales order rows in the Cdb cache.

Filtering attributes is particularly useful for MBOs that have large amounts of data that does 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, to load only California customers for a device application, set the "state" attribute as the Filter by attribute.