Creating a Data Source for Linked Parameters

To implement linked parameters, you must first build a mobile business object that contains all of the dependent values and the relationship between the values.

The mobile business object can use any data source, for example:

A database table
A web service
Result-set filter generated

The data output from these data sources must be converted into a table of a specific format by utilizing a transformation method, for example, using an XSLT template for the Web service output, or using a stored procedure or properly formatted SQL query.

Required attribute names for linked parameters are:

"index"
"display_name"
"value_data"
"value_name"
"link"

For example, a properly formatted SQL table would look like this:

CREATE TABLE "dba" . "linked_params" (
"index" INT NOT NULL ,
"display_name" VARCHAR (50) NOT NULL ,
"value_data" VARCHAR (50) NOT NULL ,
"value_name" VARCHAR (50) NOT NULL ,
"link" INT NOT NULL ,
)
IN SYSTEM
;
ALTER TABLE "dba" . "linked_params"
  ADD CONSTRAINT "ASA105" PRIMARY KEY CLUSTERED ( "index" )
;
ALTER TABLE "dba" . "linked_params"
  ADD CONSTRAINT "ASA106" UNIQUE NONCLUSTERED ( "index" )
;