Implementing Custom Result Set Filters

Developers can write a filter to add, delete, or change columns as well as to add and delete rows.

Prerequisites

To write a filter, developers must have previous experience with Java programming — particularly with the reference implementations for javax.sql.RowSet, which is used to implement the filter interface and described in the JDBC RowSet Implementations Tutorial at http://docs.oracle.com/javase/tutorial/jdbc/basics/jdbcrowset.html.

Note: SAP strongly encourages developers to initially create filters in SAP Mobile WorkSpace: a wizard assists you by autogenerating required imports and methods so the implementation compiles and runs. Then to customize the code, you can cut and paste fragments from the sample, and make the required changes to get the desired end result.

Task

Once the filter has been implemented and deployed to SAP Mobile Server as part of an MBO package, the MBO developer can apply the filter to other MBOs from SAP Mobile WorkSpace. See Adding a Result Set Filter in SAP Mobile WorkSpace - Mobile Business Object Development.

Note: Validate the performance of any custom result set filters, before deploying packages to SAP Mobile Server.