Grid with XML data question

[jahnvi25Participant]

here is my sample xml which i am trying to load in jqxGrid.. i have different column where i want to assign node value based on attribute..

like col1 should have all call_recs–>field(‘symbol’)
col2 = call_recs –> fields(‘expire’);
col3 = put_recs –>fields(‘symbol’);

how can i do this if i specify datatype = ‘xml’ while initializing source ?

MSFT

MSFT1312D20
MSFT1312D21

…
…
…
…
…
…
…
…
…

MSFT1312D20
MSFT1312D21

[jahnvi25Participant]

sorry my xml somehow not showing correct values.. trying one more time

MSFTMSFT1312D20MSFT1312D21………………………MSFT1312D20MSFT1312D21

[jahnvi25Participant]

finally hopefully correct xml ::

<wddxPacket version="1.0">
<header/>
<data>
<struct>
<var name="BASE_SYMBOL">
<string>MSFT</string>
</var>
<var name="CALL_RECS">
<recordset rowCount="189" fieldNames="SYMBOL,EXPIRE,STRIKE,LAST,CHANGE,BID,ASK,VOLUME,OPENINT,SUCCESS">
<field name="SYMBOL">
<string>MSFT1312D20</string>
<string>MSFT1312D21</string>
</field>
<field name="EXPIRE">...</field>
<field name="STRIKE">...</field>
<field name="LAST">...</field>
<field name="CHANGE">...</field>
<field name="BID">...</field>
<field name="ASK">...</field>
<field name="VOLUME">...</field>
<field name="OPENINT">...</field>
<field name="SUCCESS">...</field>
</recordset>
</var>
finally correct xml hoefully ...
<var name="PUT_RECS">
<recordset rowCount="189" fieldNames="SYMBOL,EXPIRE,STRIKE,LAST,CHANGE,BID,ASK,VOLUME,OPENINT,SUCCESS">
<field name="SYMBOL">
<string>MSFT1312D20</string>
<string>MSFT1312D21</string>
</field>
<field name="EXPIRE"/>
<field name="STRIKE"/>
<field name="LAST"/>
<field name="CHANGE"/>
<field name="BID"/>
<field name="ASK"/>
<field name="VOLUME"/>
<field name="OPENINT"/>
<field name="SUCCESS"/>
</recordset>
</var>
</struct>
</data>
</wddxPacket>

[jahnvi25Participant]

any answer for this one ?

[Author]

Posts