Assume you want to subset the download of a table called Customer by MobiLink user and you also want to only download rows where active=1. The MobiLink user names do not exist in the table you are subsetting, so you must create a join to a table called SalesRep, which contains the user names. This example assumes timestamp-based download.

To configure synchronization for this scenario, type the following into Tables To Add To The Download Cursor's FROM Clause:

SalesRep

Type the following into SQL Expression to Use In The Download Cursor's WHERE Clause:

SalesRep.ml_username = {ml s.username} 
   AND Customer.active = 1
   AND Customer.cust_id = SalesRep.cust_id

The following download_cursor script is generated based on these settings:

SELECT "DBA"."Customer"."cust_id",
 "DBA"."Customer"."cust_name"
FROM "DBA"."Customer", SalesRep
WHERE "DBA"."Customer"."last_modified" >= {ml s.last_table_download}
 AND SalesRep.ml_username = {ml s.username}
 AND Customer.active = 1
 AND Customer.cust_id = SalesRep.cust_id

The final line of the WHERE clause creates a key join of Customer to SalesRep.

You can view and modify this script, after the Create Synchronization Model Wizard finishes, in the Events tab. See Modifying the download subset.

• Introduction to MobiLink users
• Remote IDs
• Partitioning rows among remote databases
• Using remote IDs and MobiLink user names in scripts
• Using last download times in scripts
• Writing download_cursor scripts