Need help with XML data output - BI Publisher
Hello all, I have the following XML output, but I need my custom BI Publisher template to parse through each group (G_BOX_18_TO_20) from the top and only get the first one that has <W2_LOCAL_WAGES> greater than 0. Is it possible?
<LIST_G_BOX_18_TO_20>
<G_BOX_18_TO_20>
<SD_CODE></SD_CODE>
<ASSIGNMENT_ACTION_ID5>2246979525</ASSIGNMENT_ACTION_ID5>
<PAYROLL_ACTION_ID5>30571317</PAYROLL_ACTION_ID5>
<TAX_UNIT_ID4>120</TAX_UNIT_ID4>
<LOCALITY_NAME1>Chardon(OH)</LOCALITY_NAME1>
<STATE_ABBREV>OH</STATE_ABBREV>
<W2_LOCAL_WAGES>0</W2_LOCAL_WAGES>
<W2_LOCAL_INCOME_TAX>0</W2_LOCAL_INCOME_TAX>
</G_BOX_18_TO_20>