You must transform, or generate the data source to produce data in the required format for linked parameters.
Sybase Unwired Platform includes two XSLT files (CategoryTypeItem.xsl and RegionSiteDepartment.xsl) located in <SUP Installation Directory>\UnwiredPlatform\Unwired_Workspace\samples that you can modify and use in conjunction with Remedy Web Services. You can use the included XSLT files to build MBOs to produce the Category-Type-Item or Region-Site-Department dependent field values (linked parameters) that are common in the Remedy HelpDesk and other applications.
If you use a different application or data source, you can use your own transformation or generation techniques to produce the data in a similar format to that required for linked parameters.
This example shows the CategoryTypeItem XSLT:
This shows a preview of a mobile business object that uses linked parameters:
This creates a sample linked table using Remedy data.
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 NULL, ) IN SYSTEM ; ALTER TABLE "dba"."linked_params" ADD CONSTRAINT "ASA105" PRIMARY KEY CLUSTERED ("index") ; ALTER TABLE "dba"."linked_params" ADD CONSTRAINT "ASA105" PRIMARY KEY CLUSTERED ("index") ; INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (1, 'Category', 'default', 'Default', null); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (2, 'Category', 'hardware', 'Hardware', null); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (3, 'Category', 'software', 'Software', null); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (4, 'Type', 'default', 'Default', 1); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (5, 'Type', 'drive', 'Drive', 2); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (6, 'Type', 'laptop', 'Laptop', 2); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (7, 'Type', 'memory', "Memory', 2); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (8, 'Type', 'email', 'Email', 3); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (9, 'Type', 'internet', 'Internet', 3); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (10, 'Item', 'default', 'Default', 4); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (11, 'Item', 'dvd drive', 'DVD Drive', 5); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (12, 'Item', 'hard drive', 'Hard Drive', 5); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (13, 'Item', 'zip drive', 'Zip Drive', 5); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (14, 'Item', 'apple', 'Apple', 6); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (15, 'Item', 'deli', 'Deli', 6); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (16, 'Item', 'ibm', 'IBM', 6); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (17, 'Item', 'memory', 'Memory', 7); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (18, 'Item', 'outlook', 'MS Outlook', 8); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (19, 'Item', 'outlook express', 'MS Outlook Express', 8); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (20, 'Item', 'access', 'Access', 9); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (21, 'Item', 'ftp', 'FTP', 9); INSERT INTO dba.linked_params ("index", "display_name", "value_data", "value_name", "link") VALUES (22, 'Item', 'other', 'Other', 9);