Following is my xml file.
<EMPLOYEES>
<EMPLOYEE EmpId="194">
<NAME>SURESH KUMAR</NAME>
<EMPNO>E1001</EMPNO>
<DESIGNATION>Developer</DESIGNATION>
<PAY id="1">9500</PAY>
<PAY id="2">4750</PAY>
<PAY id="3">800</PAY>
<PAY id="4">1000</PAY>
<PAY id="5">650</PAY>
<PAY id="6">1000</PAY>
<PAY id="7">1140</PAY>
<GROSS>17700.0</GROSS>
<DEDUCTIONS>1140.0</DEDUCTIONS>
<NETPAY>16560.0</NETPAY>
</EMPLOYEE>
<EMPLOYEE EmpId="196">
<NAME>ANNAND KUMAR</NAME>
<EMPNO>E1002</EMPNO>
<DESIGNATION>Developer</DESIGNATION>
<PAY id="1">7000</PAY>
<PAY id="2">3500</PAY>
<PAY id="3">800</PAY>
<PAY id="4">800</PAY>
<PAY id="5">500</PAY>
<PAY id="6">800</PAY>
<PAY id="7">840</PAY>
<GROSS>13400.0</GROSS>
<DEDUCTIONS>840.0</DEDUCTIONS>
<NETPAY>12560.0</NETPAY>
</EMPLOYEE>
---
---
<EMPLOYEE EmpId="197">
</EMPLOYEES>
Using <xsl:for-each select="EMPLOYEES/EMPLOYEE">, I am iterating through each EMPLOYEE details and populating a table. Within each <EMPLOYEE>, how can I access all the <PAY> element and its data.
In my xsl, I have like this:
<xsl:for-each select="EMPLOYEES/EMPLOYEE">
<tr>
<td><xsl:value-of select="EMPNO"/></td>
<td><xsl:value-of select="NAME"/></td>
<td><xsl:value-of select="DESIGNATION"/></td>
//Here I want iterate all the <PAY> elements within a <EMPLOYEE>
<xsl:for-each select="/PAY">
<td><xsl:value-of select="PAY"/></td>
</xsl:for-each>
<td><xsl:value-of select="GROSS"/></td>
<td><xsl:value-of select="DEDUCTIONS"/></td>
<td><xsl:value-of select="NETPAY"/></td>
</tr>
</xsl:for-each>
I think, I am wrong with the x-path!! Please help!
<xsl:for-each> inside another <xsl:for-each>
