You develop an MBO named "salesOrder" and define a Filter by parameter named "region". The default value of "region" is "Eastern." Once the MBO is deployed to Unwired Server, the implications of setting Filter by are:
- The Unwired Server Cache (consolidated database or Cdb) is partitioned for the MBO data based on the value of the Filter by parameter. In this example, the "region" parameter is passed to the database MBO:
select * from sales_order where region = ?
- The results from the select query populate the salesOrder MBO, but the MBO data's cache Cdb is also partitioned by the region value (Eastern). Meaning that when the MBO executes with region equal to "Eastern", the set of rows returned is compared against the previously cached results only from a previous execution of the query with region equal to "Eastern". None of the CDb rows containing salesOrder data for the region equal to "Southern" are considered in this differential calculation.
If the developer unselects
Filter by, redeploys, and runs this query against the MBO:
select * from sales_order where region = ?