Bookshelf Home | Contents | Index | PDF |
Siebel Portal Framework Guide > Delivering Content to External Web Applications > Common Operations > Querying ItemsTo successfully perform a query, you must first navigate to a screen that allows queries. You must then send two separate requests to the SWE XML application. The first request executes the Create New Query action, and the second executes the Execute Query action. NewQuery<?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> ExecuteQueryIn the ExecuteQuery 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">ExecuteQuery</ARG> <ARG NAME="SWEView">view name</ARG> <ARG NAME="SWEApplet">applet name</ARG> <ARG NAME="column name">search criteria</ARG> <ARG NAME="SWESetMarkup">XML</ARG> <ARG NAME="SWEDataOnly">TRUE</ARG> <ARG NAME="SWESetNoTemp">TRUE</ARG> The auction items that match the query are returned in the response. The returned payload contains complete lot names and IDs for each item. TIP: Each row (or record) within a response contains an ID that uniquely identifies it. You can use a row ID as a parameter in a query to identify a record so that you can modify or delete it. Adding RecordsTo successfully add a record to a list, you must first navigate to a screen that allows records to be inserted. Then, you must send two separate requests to the SWE XML application. The first request executes the New Record action. The second executes the WriteRecord action. NewRecordIn a NewRecord command block, you use <?xml version="1.0" encoding="UTF-8"?> <EXEC PATH="/callcenter/start.swe"> <CMD NAME="SWECmd" VALUE="InvokeMethod"> <ARG NAME="SWEMethod">NewRecord</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> 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 © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |