How Can I access child loop element inside parent for each loop based on condition in rtf template

Kaustubh Deshmukh

Content

Nested for each to get child element based on parent loop condition

I have two different groups in xml files 1. GLB_PAY_ARCH_PR_EARNINGS and 2.GLB_PAY_ARCH_PR_HOURS_X_RATE both having common field

REPORTING_NAME .I need data like for every Earninngs_name from (GLB_PAY_ARCH_PR_EARNINGS).it should return hours from (GLB_PAY_ARCH_PR_HOURS_X_RATE) group.

Getting Blank result for below code

Output Example:

Earning_name                 Hours

EAR1                                 12

EAR2                                  8

<?for-each-group:/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/GLB_ARCH_PR/GLB_PAY_ARCH_PR_INFO/GLB_ARCH_CBID/GLB_PAY_ARCH_CBID_INFORMATION/GLB_ARCH_TRU/GLB_PAY_ARCH_PR_EARNINGS;./REPORTING_NAME?>
<?for-each:GLB_PAY_ARCH_PR_HOURS_X_RATE[REPORTING_NAME= current-group()/REPORTING_NAME]?>
<?if:REPORTING_NAME!= 'Basic Pay'?>
<?EARNINGS_HOURS?>
<?end if?>
<?end for-each?>
<?end for-each-group?>

 

Thanks