Need help in retrieving values from a loop !
Hi ,
Need one help with a xslt loop. I've the following xml :
<ns0:PartnerQualifications>
<ns0:Qualification>
<ns0:QualificationType>Premier Certified Partner</ns0:QualificationType>
<ns0:QualificationCode>CERT</ns0:QualificationCode>
</ns0:Qualification>
<ns0:Qualification>
<ns0:QualificationType>Exclusive Partner</ns0:QualificationType>
<ns0:QualificationCode>CERT</ns0:QualificationCode>
</ns0:Qualification>
<ns0:Qualification>
<ns0:QualificationType>Content Networking Specialization</ns0:QualificationType>
<ns0:QualificationCode>SPECIAL</ns0:QualificationCode>
</ns0:Qualification>
<ns0:Qualification>
<ns0:QualificationType>Switch Networking</ns0:QualificationType>
<ns0:QualificationCode>SPECIAL</ns0:QualificationCode>
</ns0:Qualification>
<ns0:Qualification>
<ns0:QualificationType>ATP - Optical - Metro Transport</ns0:QualificationType>
<ns0:QualificationCode>AUTH</ns0:QualificationCode>
</ns0:Qualification>
<ns0:Qualification>
<ns0:QualificationType>Metro Transport</ns0:QualificationType>
<ns0:QualificationCode>AUTH</ns0:QualificationCode>
</ns0:Qualification>
</ns0:PartnerQualifications>
I need to iterate thru this xml and seperate out the values (comma seperated) based on QualificationCode . So the end result will be like :
Premier Certified Partner,Exclusive Partner --> based on AUTH
Content Networking Specialization, Switch Networking --> based on SPECIAL
ATP - Optical - Metro Transport, Metro Transport --> based on AUTH
What I tried was (for CERT type only):
<tr bgcolor="#FFFFFF">
<th width="200">Partner/Reseller Certification</th>
<td class="tablecontent" align="center">
<xsl:for-each select="ns0:PromotionHeader/ns0:PartnerQualifications/ns0:Qualification/ns0:QualificationType">
<xsl:if test="ns0:PromotionHeader/ns0:PartnerQualifications/ns0:Qualification/ns0:QualificationCode = 'CERT'">
<xsl:value-of select="."/>
<xsl:if test="position() < last()">,</xsl:if>
</xsl:if>
</xsl:for-each>
</td>
</tr>
The if loop is wrong as it needs to be check the value within that particular <ns0:Qualification> .
Any pointer will be highly appreciated.
Thanks,
Shamik
|