QAS_GETQUERYRESULTS

QAS_GETQUERYRESULTS_OPER

This service operation is used to retrieve the query results.

Request Message: QAS_GETQUERYRESULTS_REQ_MSG

Element Name	Description
BlockNumber	The number of blocks to be retrieved. Query result is retrieved starting from block 1 in sequential order until the final block is retrieved. Note: The block that contains status finalBlockRetrieved is the final block.
QueryInstance	Query instance ID.

Element Name

Description

BlockNumber

The number of blocks to be retrieved.

Query result is retrieved starting from block 1 in sequential order until the final block is retrieved.

Note: The block that contains status finalBlockRetrieved is the final block.

QueryInstance

Query instance ID.

Example Request:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:qas="http://xmlns.oracle.com/Enterprise/Tools/schemas/
QAS_GETQUERYRESULTS_REQ_MSG.VERSION_1"
xmlns:qas1="http://xmlns.oracle.com/Enterprise/Tools/schemas/
QAS_GETQUERYRESULTS_REQ.VERSION_1">
   <soapenv:Header/>
   <soapenv:Body>
      <qas:QAS_GETQUERYRESULTS_REQ_MSG>
         <!--Zero or more repetitions:-->
         <qas:QAS_GETQUERYRESULTS_REQ>
            <qas1:PTQASWRK class="R">
               <qas1:BlockNumber>1</qas1:BlockNumber>
               <qas1:QueryInstance>
                  8995a01e-0a75-11dd-9c24-98a15db6aa18
               </qas1:QueryInstance>
            </qas1:PTQASWRK>
         </qas:QAS_GETQUERYRESULTS_REQ>
      </qas:QAS_GETQUERYRESULTS_REQ_MSG>
   </soapenv:Body>
</soapenv:Envelope>

Response Message: QAS_GETQUERYRESULTS_RESP_MSG

Depending on the output format requested, the response will be either a file URL or the query result in webrowset or XMLP format.

Element Name	Description
FILEURL	Returns FILE URL.
status	If the output format is file, the return status will be either success or failure. If the output format is non file the return status will be one of the following: running or queued indicates that clients have to continue polling for the same block until a status blockRetrieved or finalBlockRetrieved is returned. blockRetrieved indicates that the clients have received 1 block of query result and will have to poll for the next block. finalBlockRetrieved indicates that there are no more blocks to retrieve and clients can stop polling for results.

Element Name

Description

FILEURL

Returns FILE URL.

status

If the output format is file, the return status will be either success or failure.

If the output format is non file the return status will be one of the following:

running or queued indicates that clients have to continue polling for the same block until a status blockRetrieved or finalBlockRetrieved is returned.
blockRetrieved indicates that the clients have received 1 block of query result and will have to poll for the next block.
finalBlockRetrieved indicates that there are no more blocks to retrieve and clients can stop polling for results.

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_GETQUERYRESULTS_RESP_MSG xmlns="http://xmlns.oracle.com/
      Enterprise/Tools/schemas/QAS_GETQUERYRESULTS_RESP_MSG.VERSION_1">
         <QAS_QUERYRESULTS_FILE_RESP xmlns="http://xmlns.oracle.com/
          Enterprise/Tools/schemas/QAS_QUERYRESULTS_FILE_RESP.VERSION_1">
            <FILEURL>
               http://ple-infodev-09.example.com:8010/psreports/QEDMO⇒
               /9999911/XRFWIN.xml
            </FILEURL>
            <status>success</status>
         </QAS_QUERYRESULTS_FILE_RESP>
      </QAS_GETQUERYRESULTS_RESP_MSG>
   </soapenv:Body>
</soapenv:Envelope>