Skip to Content
0
Jan 26, 2020 at 06:32 AM

Filter Condition in sap cpi

113 Views

Hi All,

Am trying to filter the data with a small condition but am not getting where am failing.

XML:

<?xml version="1.0" encoding="UTF-8"?>
<root>
<row><FIELD5>REQUEST DETAIL</FIELD5><FIELD6>12</FIELD6><FIELD7>2020-01-19</FIELD7><FIELD8>1</FIELD8><FIELD9>1009</FIELD9><FIELD10>AMARWAN</FIELD10><FIELD11>YOUSEF</FIELD11><FIELD12>O</FIELD12><FIELD13>GCA</FIELD13><FIELD14>PCLNT0</FIELD14><FIELD15>1000</FIELD15><FIELD16>CC</FIELD16><FIELD17>C1504</FIELD17><FIELD18/><FIELD19/><FIELD20/><FIELD21/><FIELD22/><FIELD23/><FIELD24/><FIELD25/><FIELD26/><FIELD27/><FIELD28/><FIELD29/><FIELD30/><FIELD31/><FIELD32/><FIELD33/><FIELD34/><FIELD35/><FIELD36/><FIELD37/><FIELD38/><FIELD39/><FIELD40/><FIELD41/><FIELD42/><FIELD43>333R</FIELD43><FIELD44>19</FIELD44><FIELD45>DEFAULT</FIELD45><FIELD46>SAR</FIELD46><FIELD47>SAUD</FIELD47><FIELD48>2020-01-18</FIELD48><FIELD49>2020-01-12</FIELD49><FIELD50/><FIELD51>2020-01-16</FIELD51><FIELD52/><FIELD53>UE TIP</FIELD53><FIELD54>0.00</FIELD54><FIELD55>0.00</FIELD55><FIELD56>0.00</FIELD56><FIELD57>TRAVEL</FIELD57><FIELD58>2020-01-18</FIELD58><FIELD59>1</FIELD59><FIELD60/><FIELD61/><FIELD62/><FIELD63/><FIELD64/><FIELD65>BUSINESS TRIP</FIELD65><FIELD66/><FIELD67/><FIELD68/><FIELD69/><FIELD70/><FIELD71/><FIELD72/><FIELD73/><FIELD74/><FIELD75/><FIELD76/><FIELD77/><FIELD78/><FIELD79/><FIELD80/><FIELD81>QPPR</FIELD81><FIELD82>ABUI</FIELD82><FIELD83>AE</FIELD83><FIELD84/><FIELD85/><FIELD86>0.00</FIELD86><FIELD87/><FIELD88/><FIELD89>TRAVEL</FIELD89><FIELD90/></row><row><FIELD5>REQUEST DETAIL</FIELD5><FIELD6>12</FIELD6><FIELD7>2020-01-19</FIELD7><FIELD8>2</FIELD8><FIELD9>1011</FIELD9><FIELD10>AL SETRI</FIELD10><FIELD11>MOHAMD</FIELD11><FIELD12>H</FIELD12><FIELD13>GCA</FIELD13><FIELD14>PSG00</FIELD14><FIELD15>1000</FIELD15><FIELD16>CC</FIELD16><FIELD17>C1500</FIELD17><FIELD18/><FIELD19/><FIELD20/><FIELD21/><FIELD22/><FIELD23/><FIELD24/><FIELD25/><FIELD26/><FIELD27/><FIELD28/><FIELD29/><FIELD30/><FIELD31/><FIELD32/><FIELD33/><FIELD34/><FIELD35/><FIELD36/><FIELD37/><FIELD38/><FIELD39/><FIELD40/><FIELD41/><FIELD42/><FIELD43>333T</FIELD43><FIELD44>20</FIELD44><FIELD45>DEFAULT</FIELD45><FIELD46>SAR</FIELD46><FIELD47>SAUDA</FIELD47><FIELD48>2020-01-18</FIELD48><FIELD49>2020-01-12</FIELD49><FIELD50/><FIELD51>2020-01-16</FIELD51><FIELD52/><FIELD53>UAE TRIP</FIELD53><FIELD54>0.00</FIELD54><FIELD55>0.00</FIELD55><FIELD56>0.00</FIELD56><FIELD57>TRAVEL</FIELD57><FIELD58>2020-01-18</FIELD58><FIELD59>1</FIELD59><FIELD60/><FIELD61/><FIELD62/><FIELD63/><FIELD64/><FIELD65>CONFERENCE / WORKSHOPS / SEMINAR</FIELD65><FIELD66/><FIELD67/><FIELD68/><FIELD69/><FIELD70/><FIELD71/><FIELD72/><FIELD73/><FIELD74/><FIELD75/><FIELD76/><FIELD77/><FIELD78/><FIELD79/><FIELD80/><FIELD81>Q_APPR</FIELD81><FIELD82>ABU</FIELD82><FIELD83>AE</FIELD83><FIELD84/><FIELD85/><FIELD86>0.00</FIELD86><FIELD87/><FIELD88/><FIELD89>TRAVEL</FIELD89><FIELD90/></row><row><FIELD5>REQUEST DETAIL</FIELD5><FIELD6>12</FIELD6><FIELD7>2020-01-19</FIELD7><FIELD8>3</FIELD8><FIELD9>1011</FIELD9><FIELD10>AL SETRI</FIELD10><FIELD11>MOHAMMED</FIELD11><FIELD12>H</FIELD12><FIELD13>GCA</FIELD13><FIELD14>PSG00</FIELD14><FIELD15>1000</FIELD15><FIELD16>CC</FIELD16><FIELD17>C1500</FIELD17><FIELD18/><FIELD19/><FIELD20/><FIELD21/><FIELD22/><FIELD23/><FIELD24/><FIELD25/><FIELD26/><FIELD27/><FIELD28/><FIELD29/><FIELD30/><FIELD31/><FIELD32/><FIELD33/><FIELD34/><FIELD35/><FIELD36/><FIELD37/><FIELD38/><FIELD39/><FIELD40/><FIELD41/><FIELD42/><FIELD43>333U</FIELD43><FIELD44>21</FIELD44><FIELD45>DEFAULT</FIELD45><FIELD46>SAR</FIELD46><FIELD47>SAUA</FIELD47><FIELD48>2020-01-18</FIELD48><FIELD49>2020-01-23</FIELD49><FIELD50/><FIELD51>2020-01-25</FIELD51><FIELD52/><FIELD53>OMN</FIELD53><FIELD54>0.00</FIELD54><FIELD55>0.00</FIELD55><FIELD56>0.00</FIELD56><FIELD57>TRAVEL</FIELD57><FIELD58>2020-01-18</FIELD58><FIELD59>1</FIELD59><FIELD60/><FIELD61/><FIELD62/><FIELD63/><FIELD64/><FIELD65>TRAINING - ANNUAL</FIELD65><FIELD66/><FIELD67/><FIELD68/><FIELD69/><FIELD70/><FIELD71/><FIELD72/><FIELD73/><FIELD74/><FIELD75/><FIELD76/><FIELD77/><FIELD78/><FIELD79/><FIELD80/><FIELD81>PPR</FIELD81><FIELD82>MUST</FIELD82><FIELD83>OM</FIELD83><FIELD84/><FIELD85/><FIELD86>0.00</FIELD86><FIELD87/><FIELD88/><FIELD89>TRAVEL</FIELD89><FIELD90/></row></root>

Filter Condtion:

/root/row [ FIELD5/text() = 'REQUEST DETAIL' ] and /root/row [ FIELD65/text() = 'BUSINESS TRIP' ] or /root/row [ FIELD65/text() = 'CONFERENCE / WORKSHOPS / SEMINAR' ]

Can any one let me know where am failing.

Regards,

Sandhya