1 2 Previous Next 18 Replies Latest reply: Mar 5, 2013 2:02 AM by 894936 Go to original post RSS
      • 15. Re: how to convert table data to XML format.
        894936
        Hi ,
        Now i am able to get in correct format.

        One more concern please

        <tendermanagement xmlns="http://www.ikea.com/sarec/declaredfunds" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.prod.com/S_Dest/declaredfunds declaredFunds.xsd" buType="STO" buCode="001" sourceSystem="RIMS">
        <tendermovement date="2013-02-22T00:00:00Z" valueTendered="624" tillNo="27" transactionNo="5"/>
        <tendermovement date="2013-02-26T00:00:00Z" valueTendered="643.34" tillNo="29" transactionNo="4"/>
        <tendermanagement xmlns="http://www.ikea.com/sarec/declaredfunds" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.prod.com/S_Dest/declaredfunds declaredFunds.xsd" buType="STO" buCode="001" sourceSystem="RIMS">
          <tendermovement date="2013-02-22T00:00:00Z" booking Type="DROP"  tenderType="B2B Invoice" salesAreaGroup="STORE" valueTendered="624" tillNo="27" transactionNo="5"/>
          <tendermovement date="2013-02-26T00:00:00Z" booking Type="DROP"  tenderType="B2B Invoice" salesAreaGroup="STORE" valueTendered="643.34" tillNo="29" transactionNo="4"/>
        i want to add booking type, tender type, salesareagroup in my xml output
        • 16. Re: how to convert table data to XML format.
          odie_63
          891933 wrote:
          Now i am able to get in correct format.
          It's not a "correct" format, it's a format that embeds lots of insignificant whitespace which are just there to increase the size of the document.

          i want to add booking type, tender type, salesareagroup in my xml output
          If you understand how XMLAttributes() function works, you should be able to find out how to do it.
          What did you try?
          • 17. Re: how to convert table data to XML format.
            894936
            Hey i got it now.

            I tried with below xmlattributes.
            .................................
            , xmlagg(
                       xmlelement("tendermovement",
                         xmlattributes(
                           to_char(sales_date, 'YYYY-MM-DD"T"HH24:MI:SS"Z"') as "date"
                         , 'DROP' as "bookingType"
                         , 'B2B Invoice' as "tenderType"
                         , 'STORE' as "salesAreaGroup"
                         , invoice_total as "valueTendered"
                         , till_no as "tillNo"
                         , receipt_no as "transactionNo"
                         )
                       )
            ............................
            • 18. Re: how to convert table data to XML format.
              894936
              Thanks a lot.
              1 2 Previous Next