Bookshelf Home | Contents | Index | PDF |
Siebel Portal Framework Guide > Delivering Content to External Web Applications > Common Operations > Deleting RecordsTo successfully remove a record from the database, you must first navigate to a screen that allows records to be deleted. Then, the following three requests must be sent separately to the SWE XML application:
NOTE: When deleting a record, use a primary key (such as a row ID) as the parameter for the query. This makes sure that only one record is returned and selected in the response. If you do not use a primary key to perform the query, then several records might be returned in the response. There is a chance that the record that you want to delete is not the one selected. NewQueryWhen you delete a record, you must first execute a query to find the record you want to delete. Use search criteria, such as a primary key, to make sure that the query returns only one record. <?xml version="1.0" encoding="UTF-8"?> <EXEC PATH="/callcenter/start.swe"> <CMD NAME="SWECmd" VALUE="InvokeMethod"> <ARG NAME="SWEMethod">NewQuery</ARG> <ARG NAME="SWEView">view name</ARG> <ARG NAME="SWEApplet">applet name</ARG> <ARG NAME="SWESetMarkup">XML</ARG> <ARG NAME="SWEDataOnly">TRUE</ARG> <ARG NAME="SWESetNoTemp">TRUE</ARG> ExecuteQueryWhen you use the ExecuteQuery command block in an effort to delete a record, you must include an <?xml version="1.0" encoding="UTF-8"?> <EXEC PATH="/callcenter/start.swe"> <CMD NAME="SWECmd" VALUE="InvokeMethod"> <ARG NAME="SWEMethod">ExecuteQuery</ARG> <ARG NAME="SWEView">view name</ARG> <ARG NAME="SWEApplet">applet name</ARG> <ARG NAME="primary key column name">primary key value</ARG> <ARG NAME="SWESetMarkup">XML</ARG> <ARG NAME="SWEDataOnly">TRUE</ARG> <ARG NAME="SWESetNoTemp">TRUE</ARG> DeleteRecordYou use <?xml version="1.0" encoding="UTF-8"?> <EXEC PATH="/callcenter/start.swe"> <CMD NAME="SWECmd" VALUE="InvokeMethod"> <ARG NAME="SWEMethod">DeleteRecord</ARG> <ARG NAME="SWEView">view name</ARG> <ARG NAME="SWEApplet">applet name</ARG> <ARG NAME="SWESetMarkup">XML</ARG> <ARG NAME="SWEDataOnly">TRUE</ARG> |
Siebel Portal Framework Guide | Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |