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