Transforming a Data Source 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:

Example of a database source

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);