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

BWiech

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

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.