QAS_GETPROMPTTABLEVALUES_OPER

Use this service operation to return a list of field values for a given prompt table.

Request Message: QAS_GETPRMPTTBLVAL_REQ_MSG

Element Name	Description
PromptTableName Required element	Complete prompt record name. Required.
FieldValue	Optional search string for the key field value. If no value is entered, a list of all key values will be returned. Note: Multiple keys are not supported in PS Query. Tables with no keys are not supported in PS Query.
MaxRows	Optionally, enter the maximum number of rows to be returned. MaxRows is a number of length 10 with a decimal position of 0.

Example Request:

This request will return the first three rows of prompt table values for the table PSMSGSETDEFN.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:qas="http://xmlns.oracle.com/Enterprise/Tools/schemas/
QAS_GETPRMPTTBLVAL_REQ_MSG.VERSION_1" xmlns:qas1="http://xmlns.oracle.com/
Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_REQ.VERSION_1">
   <soapenv:Header/>
   <soapenv:Body>
      <qas:QAS_GETPRMPTTBLVAL_REQ_MSG>
         <!--Zero or more repetitions:-->
         <qas:QAS_GETPRMPTTBLVAL_REQ>
            <qas1:PTQASWRK class="R">
               <qas1:PromptTableName>psmsgsetdefn</qas1:PromptTableName>
               <!--Optional:-->
               <qas1:MaxRows>3</qas1:MaxRows>
               <!--Optional:-->
               <qas1:FieldName></qas1:FieldName>
            </qas1:PTQASWRK>
         </qas:QAS_GETPRMPTTBLVAL_REQ>
      </qas:QAS_GETPRMPTTBLVAL_REQ_MSG>
   </soapenv:Body>
</soapenv:Envelope>

Response Message: QAS_GETPRMPTTBLVALUES_RESP_MSG

Element Name	Description
FieldValue	Field value.

Example Response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <QAS_GETPRMPTTBLVAL_RESP_MSG xmlns="http://xmlns.oracle.com/
       Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP_MSG.VERSION_1">
         <QAS_GETPRMPTTBLVAL_RESP>
            <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
            Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
               <FieldValue>1</FieldValue>
            </PTQASFIELDWRK>
         </QAS_GETPRMPTTBLVAL_RESP>
         <QAS_GETPRMPTTBLVAL_RESP>
            <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
             Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
               <FieldValue>2</FieldValue>
            </PTQASFIELDWRK>
         </QAS_GETPRMPTTBLVAL_RESP>
         <QAS_GETPRMPTTBLVAL_RESP>
            <PTQASFIELDWRK class="R" xmlns="http://xmlns.oracle.com/
            Enterprise/Tools/schemas/QAS_GETPRMPTTBLVAL_RESP.VERSION_1">
               <FieldValue>3</FieldValue>
            </PTQASFIELDWRK>
         </QAS_GETPRMPTTBLVAL_RESP>
      </QAS_GETPRMPTTBLVAL_RESP_MSG>
   </soapenv:Body>
</soapenv:Envelope>