QAS_LISTQUERY_OPER

Use this service operation to return a list of queries, along with the query descriptions, and owner type. If no queries match the search string, the response message will be empty.

Request Message: QAS_LISTQUERY_REQ_MSG

Element Name All elements are optional	Description
SearchString	Search string used for specifying the query name or the first few characters of the query name. If no value is entered, all queries for the user will be returned.
OwnerType	Optionally enter either public or private for the owner type. If no value is entered, all queries both public and private for the user will be returned.
MaxRows	Optionally enter the maximum number of rows to return.
isConnectedQry	Enter Y to return list of connected queries; enter N to return list of queries. If the no value is entered, a list of all queries, including connected queries, is returned.

Example Request:

This request will retrieve a list of all public queries that start with XRFW.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:qas="http://xmlns.oracle.com/Enterprise/Tools/schemas/
QAS_LISTQUERY_REQ_MSG.VERSION_1" xmlns:qas1="http://xmlns.oracle.com/
Enterprise/Tools/schemas/QAS_LISTQUERY_REQ.VERSION_1">
   <soapenv:Header/>
   <soapenv:Body>
      <qas:QAS_LISTQUERY_REQ_MSG>
         <!--Zero or more repetitions:-->
         <qas:QAS_LISTQUERY_REQ>
            <qas1:PTQASWRK class="R">
               <!--Optional:-->
               <qas1:SearchString>XRFW</qas1:SearchString>
               <!--Optional:-->
               <qas1:OwnerType>public</qas1:OwnerType>
               <!--Optional:-->
               <qas1:MaxRows></qas1:MaxRows>
               <!--Optional:-->
               <qas:isConnectedQry></qas:isConnectedQry>
            </qas1:PTQASWRK>
         </qas:QAS_LISTQUERY_REQ>
      </qas:QAS_LISTQUERY_REQ_MSG>
   </soapenv:Body>
</soapenv:Envelope>

Response Message: QAS_LISTQUERY_RESP_MSG

Element Name	Description
QueryName	Query name.
Description	Query description.
OwnerType	Query owner type.
isConnectedQry	Connected query.

Example Response:

<?xml version="1.0"?>
<QAS_LISTQUERY_RESP_MSG xmlns="http://xmlns.oracle.com/Enterprise/
Tools/schemas/QAS_LISTQUERY_RESP_MSG.VERSION_1">
    <QAS_LISTQUERY_RESP>
        <PTQASWRK class="R" xmlns="http://xmlns.oracle.com/Enterprise/
        Tools/schemas/QAS_LISTQUERY_RESP.VERSION_1">
            <QueryName>XRFWIN</QueryName>
            <OwnerType>public</OwnerType>
            <Description>XRFWIN</Description>
            <isConnectedQry>N</isConnectedQry>
        </PTQASWRK>
    </QAS_LISTQUERY_RESP>
    <QAS_LISTQUERY_RESP>
        <PTQASWRK class="R" xmlns="http://xmlns.oracle.com/Enterprise/
        Tools/schemas/QAS_LISTQUERY_RESP.VERSION_1">
            <QueryName>XRFWNFL</QueryName>
            <OwnerType>public</OwnerType>
            <Description>XRFWNFL</Description>
            <isConnectedQry>N</isConnectedQry>
        </PTQASWRK>
    </QAS_LISTQUERY_RESP>
</QAS_LISTQUERY_RESP_MSG>