Obiee 11g Need to update mutliple columns

1059797

Hello All,

I have a requirement to update four columns on a report using writeback functionality. When I implemented this, only last column is been updated back to the database.

While updating the rest of the columns it says "Updated Successfully" but I don't see those changes on the report or on the database.

Here is my XML

<?xml version="1.0" encoding="utf-8" ?>

<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">

   <WebMessageTable lang="en-us" system="WriteBack" table="Messages">

      <WebMessage name="Test">

         <XML>

            <writeBack connectionPool="Connection Pool">

<insert> </insert>

<update> UPDATE PRODUCTS SET COMMENTS='@2' WHERE PART_NUMBER='@1'</update>

<update> UPDATE PRODUCTS SET INVENTORY='@3' WHERE PART_NUMBER='@1'</update>

<update> UPDATE PRODUCTS SET LOW='@4' WHERE PART_NUMBER='@1'</update>

<update> UPDATE PRODUCTS SET DEALER_PRICE='@5' WHERE PART_NUMBER='@1'</update>

<update> UPDATE PRODUCTS SET PRICE='@6' WHERE PART_NUMBER='@1'</update>

     </writeBack>

         </XML>

      </WebMessage>

   </WebMessageTable>

</WebMessageTables>

Frog Toad

Hi

Your xml-template should contain only one "UPDATE" and only one "INSERT"

Try to union "UPDATE"

<update> UPDATE PRODUCTS SET COMMENTS='@2', INVENTORY='@3', LOW='@4', DEALER_PRICE='@5', PRICE='@6' WHERE PART_NUMBER='@1'</update>

1059797

Thanks that worked.