QAS_LISTQUERYPROMPTS_OPER

Use this service operation to retrieve a list of the prompts and associated prompt table for a specific query.

Request Message: QAS_LISTQUERYPROMPTS_REQ_MSG

Element Name Description

QueryName

Required element

Complete Query Name. Required.

OwnerType

Optionally, enter the query owner type.

If no value is entered, both public and private are searched.

isConnectedQuery

Required element

Indicate whether this is a connected query. Required. Valid values are Y and N.

Example Request:

This request will return the prompt field and prompt table for the query TWO_PROMPT_QUERY.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:qas="http://xmlns.oracle.com/Enterprise/Tools/schemas/
QAS_LISTQUERYPROMPTS_REQ_MSG.VERSION_1"
xmlns:qas1="http://xmlns.oracle.com/Enterprise/Tools/schemas/
QAS_LISTQUERYPROMPTS_REQ.VERSION_1">
   <soapenv:Header/>
   <soapenv:Body>
      <qas:QAS_LISTQUERYPROMPTS_REQ_MSG>
         <qas:QAS_LISTQUERYPROMPTS_REQ>
            <qas1:PTQASWRK class="R">
               <qas1:QueryName>TWO_PROMPT_QUERY</qas1:QueryName>
               <!--Optional:-->
               <qas1:OwnerType>PUBLIC</qas1:OwnerType>
               <qas1:isConnectedQuery>n</qas1:isConnectedQuery>
            </qas1:PTQASWRK>
         </qas:QAS_LISTQUERYPROMPTS_REQ>
      </qas:QAS_LISTQUERYPROMPTS_REQ_MSG>
   </soapenv:Body>
</soapenv:Envelope>

Response Message: QAS_LISTQUERYPROMPTS_RESP_MSG

Element Name Description

QueryName

Query name.

FieldName

If this prompt uses a translate table, the field name for the prompt is returned.

HeadingText

Heading text for the prompt.

FieldType

Prompt field type.

FormatText

Format for the text.

FieldLength

Field length for the prompt.

FieldDecimal

Number of decimal places in the prompt field.

UniquePromptName

The unique name used for the prompt. This value is case-sensitive.

EditType

The type of edit:

  • Translate table

  • Yes/No table

  • Prompt table

  • No table edit

PromptTable

If this prompt uses a prompt table, the table name is returned.

Example Response:

This response has two prompts, one for a prompt table and one for a translate table edit.

<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_LISTQUERYPROMPTS_RESP_MSG xmlns="http://xmlns.oracle.com/
      Enterprise/Tools/schemas/QAS_LISTQUERYPROMPTS_RESP_MSG.VERSION_1">
         <QAS_LISTQUERYPROMPTS_RESP>
            <PTQASWRK class="R" xmlns="http://xmlns.oracle.com/Enterprise/
            Tools/schemas/QAS_LISTQUERYPROMPTS_RESP.VERSION_1">
               <QueryName>TWO_PROMPT_QUERY</QueryName>
               <PTQASPRMPTWRK class="R">
                  <FieldName>NODE_TYPE</FieldName>
                  <HeadingText>Node Type</HeadingText>
                  <FieldType>string</FieldType>
                  <FormatText>upper</FormatText>
                  <FieldLength>30</FieldLength>
                  <FieldDecimal>0</FieldDecimal>
                  <UniquePromptName>BIND1</UniquePromptName>
                  <EditType>Translate table</EditType>
                  <PromptTable/>
               </PTQASPRMPTWRK>
               <PTQASPRMPTWRK class="R">
                  <FieldName>PORTAL_TYPE</FieldName>
                  <HeadingText>Portal</HeadingText>
                  <FieldType>string</FieldType>
                  <FormatText>upper</FormatText>
                  <FieldLength>30</FieldLength>
                  <FieldDecimal>0</FieldDecimal>
                  <UniquePromptName>BIND2</UniquePromptName>
                  <EditType>Prompt table</EditType>
                  <PromptTable>PSPRDMDEFN</PromptTable>
               </PTQASPRMPTWRK>
            </PTQASWRK>
         </QAS_LISTQUERYPROMPTS_RESP>
      </QAS_LISTQUERYPROMPTS_RESP_MSG>
   </soapenv:Body>
</soapenv:Envelope>