How to set a 'Vertical Bar' as separator between a code and it's value in a webservices method.

Document ID : KB000058316
Last Modified Date : 28/01/2019
Show Technical Document Details
Introduction:

Description:

Use a Webservice method to set/update a form field value, holding 'code|value' data.

Solution:

This is about saving a form for a request.
And that forms contains a drop down list for selection.
I the MDB, it is saved as "form-field-name|value".
E.G. "7700|President". and "7702|CEO".
Note: "Code" and then the separator | and then it's value.

How can we use the webservices method to set this separator character correctly?

Solution:

Considering the following as an example:
In Service Catalog/catalog/forms/forms:
A FORM with field name 'site' a 'drop down' for the job_title.
Open a new request for a service with that form.
In the MDB this then looks as follows:
SELECT subscription_detail_id,form_elem_name,form_elem_value FROM usm_request_item_form where subscription_detail_id = 10021
10021 site 7700|President

To reset the value for the field 'site' use a webservices method.
The webservices method 'saveRequestForm' is then used as follows:
The 'tilde' character(~) generates the | as separator.

<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://services.soap.usm.ca.com">

 
<soapenv:Header/> <soapenv:Body>  <ser:saveRequestForm soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">  <sessionID xsi:type="xsd:string">975c56bcde83763275690856ef110e42e3c92152</sessionID>  <subscriptionDetailID xsi:type="xsd:int">10021</subscriptionDetailID>  <formValuesData xsi:type="xsd:string">site:7700~President</formValuesData> </ser:saveRequestForm> </soapenv:Body></soapenv:Envelope> 
 

NOTE:
The 'tilde' character (~) will store the |separator for the field in the MDB

Instructions:
Please Update This Required Field