Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Portal Framework Guide > Delivering Content to External Web Applications > Common Operations > Modifying RecordsTo successfully modify a record using XML, you must first navigate to a screen that allows records to be modified. Then, the following four requests must be sent separately to the SWE XML application:
NOTE: When modifying 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 update is not the one selected. NewQueryWhen you modify a record, you must first execute a query to find the record that you want to modify. The records that are returned as a result of the query are then accessible through XML. <?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 modify 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> EditRecordAfter executing the query the screen is populated with the record that you want to modify. You use the EditRecord to access the record. NOTE: If you do not use a primary key to perform the query, then several records might be returned in the response. <?xml version="1.0" encoding="UTF-8"?> <EXEC PATH="/callcenter/start.swe"> <CMD NAME="SWECmd" VALUE="InvokeMethod"> <ARG NAME="SWEMethod">EditRecord</ARG> <ARG NAME="SWEView">view name</ARG> <ARG NAME="SWEApplet">applet name</ARG> <ARG NAME="column name1">field value</ARG> <ARG NAME="column name2">field value</ARG> <ARG NAME="column nameN">field value</ARG> <ARG NAME="SWESetMarkup">XML</ARG> <ARG NAME="SWEDataOnly">TRUE</ARG> <ARG NAME="SWESetNoTemp">TRUE</ARG> WriteRecordIn a WriteRecord command block, you must include an <?xml version="1.0" encoding="UTF-8"?> <EXEC PATH="/callcenter/start.swe"> <CMD NAME="SWECmd" VALUE="InvokeMethod"> <ARG NAME="SWEMethod">WriteRecord</ARG> <ARG NAME="SWEReqRowId">1</ARG> <ARG NAME="SWEView">view name</ARG> <ARG NAME="SWERowId">row id of record to be saved</ARG> <ARG NAME="SWEApplet">applet name</ARG> <ARG NAME="SWESetMarkup">XML</ARG> <ARG NAME="SWEDataOnly">TRUE</ARG> |
![]() ![]() |
Siebel Portal Framework Guide | Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |