Help with rtf eText template navigating downward in xml output with multiple data sets at same level

Question

Hi.  I am creating output from Oracle payslip file using eText template.  I am cycling through at the payment_record level to capture output for each payment made.  Further down the tree of xml is the Gross Earnings balance.  There are 4 sets of data at that same level in the xml.  How can i cycle through them to get the one i want?

If i am at the higer level payment_record or payment_details, i can get to the values with this path GLB_ARCH_PR/GLB_PAY_ARCH_PR_INFO/GLB_ARCH_CBID/GLB_PAY_ARCH_CBID_INFORMATION/GLB_ARCH_TRU/GLB_PAY_ARCH_CLASSIFICATION_BALANCE/RUN

but it only returns the first of 4 at that level and i need the second one with base_balance_name Gross Earnings.  I have tried an if statement in the rtf but it is only looking at the first instance data set at that level.  Can i get to the one i need this way?

Any help is very appreciated.  I'm stuck.

Thanks

Sandeep S. Chauhan-Oracle · Answer

Hi, Can you share RTF(etext) and sample XML data for understanding the issue?

It would be best to reorganize your data set as per the requirement.