The Impact of Filter By on Synchronization

Filter by is an Unwired WorkSpace configuration parameter that determines synchronization behavior when a mobile business object (MBO) is created by a developer.

If a developer checks the Filter by checkbox on the Parameters tab, the value is supplied by the client each time it synchronizes the mobile business object. During a subsequent synchronization, the client may provide different values for the parameter and this affects the Enterprise Information System (EIS) data refresh results that the Unwired Server performs.

For example, an MBO has a parameter named CustomerID. The first time a client synchronizes, it passes a value of 000123, and refreshes the MBO and consolidated database (CDB) data for customer 000123. The next time the client synchronizes, the value 004321 is passed. The Sybase Unwired Server refreshes customer data for 004321 from the EIS and then downloads changes for both 000123 and 004321 to the client. If 000123 had happened to change, and the server noticed it for other reasons, than the current synchronization request, then the 000123 data may change. Essentially, when this checkbox is checked, the server remembers all the values you have ever used to synchronize this MBO and attempts to keep the client's copy of all of associated data up-to-date. The client has an ever growing subscription to various horizontal subsets of the MBO data.

If the Filter by checkbox is not checked, the client CDB contains data for only the last value that was synchronized. Using the example, when you synchronize 004321, Sybase Unwired WorkSpace inserts all 004321 data and at the same time deletes all previous 000123 data from the remote database on the device. The client gets a rolling subscription to just the horizontal subset of MBO data based on their last synchronization.


Created September 17, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com