Download subsets

Each MobiLink remote database can receive a subset of the data in the consolidated database. You can customize the download
subset for each table.

The download subset options are:

User
Choose this option to partition data by MobiLink user name, which downloads different data to different registered
MobiLink users.

To use this option, each row must contain a column that contains a MobiLink user name. You choose your MobiLink user names
when you deploy, so you can choose names that match existing values on your consolidated database. (The column that you use
for MobiLink user names must be of a type that can hold the values you are using for the user name.) If the MobiLink user
names are in a different table from the one you are subsetting, you must join to that table.

Remote ID
Choose this option to partition data by remote ID, which downloads different data to different remote databases.

To use this option, each row must contain a column that holds a remote ID. Remote IDs are created as GUIDs by default, but
you can set the remote IDs to match existing values on your consolidated database. (The column you use for remote IDs must
be of a type that can hold the values you are using for the remote IDs.) If the remote IDs are in a different table from the
one you are subsetting, you must join to that table.

Note

It is usually better to partition by user or by authentication parameter than by remote ID, because the remote ID can change
if the remote computer is reset or replaced.

Custom
Choose this option to use a SQL expression that determines which rows are downloaded. Each synchronization only downloads
rows where your SQL expression is true. This SQL expression is added to the WHERE clause of the generated download_cursor
script. You can use MobiLink named parameters in the expression. You can also refer to other tables. If you refer to other
tables, you must list the other tables in the field above the expression, and include the join condition in your expression.