Bookshelf v8.1/8.2: About the LOV Service

The LOV service provides external Web applications the ability to query for lists of values (LOV) from the Siebel database. The published Web service is named EAILOVWS and is based on the EAI LOV Service business service.

The LOV service exposes one method, GetListOfValues. Table 7 describes the method and the method arguments.

Table 7. LOV Service Methods and Method Arguments
Method	Description	Arguments
		Type	Name	Description
GetListOfValues	Retrieves lists of values to display in picklist fields.	Input	ListsTopElementQuery	Takes the List Query integration object as input
GetListOfValues	Retrieves lists of values to display in picklist fields.	Output	ListsTopElementResult	Returns the List Result integration object

Table 8 summarizes the hierarchy of the List Query and List Result integration objects.

Table 8. List Query and List Result Integration Object Hierarchy
Integration Object		Integration Object Component		Integration Object Component Fields
Name	XML Tag	Name	XML Tag	Name	XML Tag
List Query	ListQuery	List	ListQuery	Active	Active
				Filter Value	FilterValue
				Language Code	LanguageCode
				Type	Type
List Result	ListsResult	List	ListResult	Type	Type
		List Value	ListValueResult	Active	Active
				Description	Description
				Display Value	DisplayValue
				Filter Value1	FilterValue
				Language Code	LanguageCode
				Order	Order
				Value	Value

1You cannot use the Filter Value field for searching.

Example of an LOV Service Request

The following example request demonstrates invoking the LOV business service to query for two LOV types, TRAINING_LOC_REGION and MR_MS.

   <soapenv:Body>
      <EAILOVService_EAILOVGetListOfValues_Input xmlns="http://www.siebel.com/xml/LOVService">
         <ns3:ListsQuery xmlns:ns3="http://www.siebel.com/xml/ListQuery">
            <ns3:ListQuery>
               <ns3:Type>TRAINING_LOC_REGION</ns3:Type>
            </ns3:ListQuery>
            <ns3:ListQuery>
               <ns3:Type>MR_MS</ns3:Type>
            </ns3:ListQuery>
         </ns3:ListsQuery>
      </EAILOVService_EAILOVGetListOfValues_Input>
   </soapenv:Body>

Example of an LOV Service Response

The following example shows the response from the LOV Service to the query for two LOV types, TRAINING_LOC_REGION and MR_MS.

   <SOAP-ENV:Body>
      <ns:EAILOVService_EAILOVGetListOfValues_Output xmlns:ns="http://www.siebel.com/xml/LOVService">
         <ListsResult xmlns="http://www.siebel.com/xml/ListResult">
            <ListResult>
               <Type>TRAINING_LOC_REGION</Type>
               <ListValuesResult>
                  <ListValueResult>
                     <Active>Y</Active>
                     <Description></Description>
                     <DisplayValue>Asia</DisplayValue>
                     <FilterValue></FilterValue>
                     <LanguageCode>ENU</LanguageCode>
                     <Order>3</Order>
                     <Value>Asia</Value>
                  </ListValueResult>
                  <ListValueResult>
                     <Active>Y</Active>
                     <Description></Description>
                     <DisplayValue>Europe</DisplayValue>
                     <FilterValue></FilterValue>
                     <LanguageCode>ENU</LanguageCode>
                     <Order>2</Order>
                     <Value>Europe</Value>
                  </ListValueResult>
                  <ListValueResult>
                     <Active>Y</Active>
                     <Description></Description>
                     <DisplayValue>Latin America</DisplayValue>
                     <FilterValue></FilterValue>
                     <LanguageCode>ENU</LanguageCode>
                     <Order>4</Order>
                     <Value>Latin America</Value>
                  </ListValueResult>
               </ListValuesResult>
            <ListResult>
               <Type>MR_MS</Type>
               <ListValuesResult>
                  <ListValueResult>
                     <Active>Y</Active>
                     <Description></Description>
                     <DisplayValue>Dr.</DisplayValue>
                     <FilterValue></FilterValue>
                     <LanguageCode>ENU</LanguageCode>
                     <Order>4</Order>
                     <Value>Dr.</Value>
                  </ListValueResult>
                  <ListValueResult>
                     <Active>Y</Active>
                     <Description></Description>
                     <DisplayValue>Miss</DisplayValue>
                     <FilterValue></FilterValue>
                     <LanguageCode>ENU</LanguageCode>
                     <Order>1</Order>
                     <Value>Miss.</Value>
                  </ListValueResult>
               </ListValuesResult>
            </ListResult>
         </ListsResult>
      </ns:EAILOVService_EAILOVGetListOfValues_Output>
   </SOAP-ENV:Body>

Siebel Web UI Dynamic Developer Kit Guide		Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.