XML + XSLT Compare Nodes

tommyready · September 3rd, 2007, 02:53 PM

Okay,

Very simple for some of you I'm sure. I want to compare to node values and if they don't match apply a class from my style sheet. I know how to apply the css class, but what I can't do is compare the nodes. Can anyone help me with that. Below is sample data:

In this sample I want to test and see if MentorQty = EBOMQty.

Code:

<?xml version="1.0" encoding="utf-8"?>
<BOMResolutionReport>   
<ComponentList>
      <Component>
         <Line>
            <MentorFindNumber>106</MentorFindNumber>
            <MentorQty>1.0</MentorQty>
            <MentorComponentName>A-0000200-01</MentorComponentName>
            <EBOMFindNumber>106</EBOMFindNumber>
            <EBOMQty>1.0</EBOMQty>
            <EBOMComponentName>A-0000200-01</EBOMComponentName>
            <EBOMDescription>Test Part for Master Mapping</EBOMDescription>
            <FormPer>the form per</FormPer>
            <SeeView>the note</SeeView>
            <SeeNote>the view</SeeNote>
            <Caution>this is the caution</Caution>   
            <Status>Full Match</Status>
            <MappingUsed>Master</MappingUsed>
         </Line>

      </Component>
</BOMResolutionReport>

Can anyone help me with this? Many Thanks if you can!!

Here is my general logic:

Code:

<xsl:if test="BOMResolutionReport/ComponentList/Component/Line/MentorQty = BOMResolutionReport/ComponentList/Component/Line/EBOMQty">
      <xsl:attribute name="class">yellowbg</xsl:attribute>
</xsl:if>

mhkay · September 3rd, 2007, 03:21 PM

>In this sample I want to test and see if MentorQty = EBOMQty.

If Line is the context item you can do

<xsl:if test="MentorQty = EBOMQty">

If you tried that and it didn't work, you probably got the context wrong; but one can't really tell what was wrong with your code without seeing it.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

tommyready · September 3rd, 2007, 03:27 PM

This is my code:

Code:

<td>
   <xsl:for-each select="MentorQty">
      <xsl:choose>
         <xsl:when test="node()[not(.='null')]">
            <xsl:choose>
               <xsl:when test="MentorQty = EBOMQty">
                  <xsl:attribute name="class">yellowbg</xsl:attribute>
               </xsl:when>
            </xsl:choose>

            <xsl:apply-templates />
         </xsl:when>

         <xsl:otherwise>N/A</xsl:otherwise>
      </xsl:choose>
   </xsl:for-each>
</td>

I don't get any error messages, but I don't get anything with the yellowbg class applied either. I know the xsl:attribute works fine because I use it on other parts of this file.

mhkay · September 4th, 2007, 01:30 AM

When you do <xsl:for-each select="MentorQty"> the context changes from the Line element to the MentorQty element, so the comparison needs to become test=". = ../EBOMQty"

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

tommyready · September 4th, 2007, 07:05 AM

Ok,

I found a fix for my problem. I had my test for MentorQty != EBOMQty in wrong place.

Code:

<td>
   <xsl:if test="EBOMQty != MentorQty">
      <xsl:attribute name="class">yellowbg</xsl:attribute>
   </xsl:if>

   <xsl:for-each select="EBOMQty">
      <xsl:choose>
         <xsl:when test="node()[not(.='null')]">
            <xsl:apply-templates />
         </xsl:when>

         <xsl:otherwise>0</xsl:otherwise>
      </xsl:choose>
   </xsl:for-each>
</td>

By moving it outside of my xsl:for-each it worked. I have no idea why, it just did.

mhkay · September 5th, 2007, 03:18 AM

>By moving it outside of my xsl:for-each it worked. I have no idea why, it just did.

The fact that you still don't understand the cause is depressing, given that I explained to you that it was because xsl:for-each changed the context. Please don't just use trial and error - read the sections on XPath context and xsl:for-each in your favourite textbooks, and ask questions here if you don't understand them.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference