BI Publisher (MOSC)

MOSC Banner

Need help with XML data output - BI Publisher

edited Dec 10, 2018 5:36PM in BI Publisher (MOSC) 5 commentsAnswered ✓

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>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center