Deleting a Query
QAS provides a service operation to delete a query in the PeopleSoft database. Query security will allow only authorized users to delete a query. Only the query owner can delete a private query.
Note: Connected queries cannot be deleted using QAS.
This section describes the following service opeartions that are available to delete a query:
QAS_QUERY_DELETE_OPER
QAS_QUERY_DELETE_REST_DELETE
This service operation is used to delete an existing query.
Request Message: QAS_QUERY_DELETE_REQ_MSG
|
Element Name |
Description |
|---|---|
|
QUERY_NAME Required element |
Complete query name. Required. |
Example Request:
This is an example of a request to delete the query MGR_TEST.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:qas="http://xmlns.oracle.com/Enterprise/Tools/schemas/
QAS_QUERY_DELETE_REQ_MSG.VERSION_1">
<soapenv:Header/>
<soapenv:Body>
<qas:QAS_QUERY_DELETE_REQ_MSG>
<QUERY_NAME>MGR_TEST</QUERY_NAME>
</qas:QAS_QUERY_DELETE_REQ_MSG>
</soapenv:Body>
</soapenv:Envelope>Response Message: QAS_QUERY_DELETE_RESP_MSG
|
Element Name |
Description |
|---|---|
|
STATUS |
Status of the delete operation, either Success orFailure. |
|
INFO_MESSAGE |
If the status is Failure, the reason for the failure is indicated. |
This service operation is used to delete an existing query.
Request Message: QAS_QUERY_DELETE_TEMPL
|
Element Name |
Description |
|---|---|
|
QUERY_NAME Required element |
Complete query name. Required. |
Example Request:
This is an example of a request to delete the query MGR_TEST.
https://<servername>:<port>/PSIGW/RESTListeningConnector/<default local node>/QueryDelete.v1/XRFWIN2
Response Message: QAS_QUERY_DELETE_RESP_MSG
|
Element Name |
Description |
|---|---|
|
STATUS |
Status of the delete operation, either Success orFailure. |
|
INFO_MESSAGE |
If the status is Failure, the reason for the failure is indicated. |
Example Response:
<?xml version="1.0"?>
<qcs:QAS_QUERY_DELETE_RESP_MSG xmlns:qcs="http://xmlns.oracle.com/
Enterprise/Tools/schemas/QAS_QUERY_DELETE_RESP_MSG.VERSION_1">
<STATUS>Success</STATUS>
</qcs:QAS_QUERY_DELETE_RESP_MSG>