How to compare the value of two nodes in XSLT

Question

I am new to XSLT. I need help comparing the value of two nodes' values in XML.

My sample XML:

<?xml version="1.0" encoding="utf-8"?>
<G1Export xmlns="">
    <AgencyGroup xmlns="">
     <Agency xmlns="">
      <RecordType xmlns="">RecordType</RecordType>
      <OrgId xmlns="">123</OrgId>
     </Agency>
    </AgencyGroup>
    <BranchGroup xmlns="">
     <BranchCode xmlns="">
      <OrgId xmlns="">123</OrgId>
     </BranchCode>
    </BranchGroup>
</G1Export>

In the above XML file I need to compare the values of the OrgId node under the <AgencyGroup> node to the one under the <BranchGroup> node.

I tried to used the compare() method, but it gives me the reult of 1. The actual result must be 0 (for equal). I am using XSLT 2.

Answer 1

//G1Export/compare(AgencyGroup//OrgId, BranchGroup//OrgId)

result = 0

Edited: There were 2 mistakes in the xslt 1. For brnchOrgId you were using AgencyGroup instead of BranchGroup 2. For the compare() you should have =0 and not ='0'

Corrected xslt:

<xsl:template match="/">
     <xsl:element name="PICRESPONSE" namespace="fieldpoint.com/namespaces">
      <xsl:for-each select="//G1Export/AgencyGroup">
       <xsl:if test="count(.) &gt; 0">
        <!--org_id variable-->
        <xsl:variable name="orgId" select="string(/G1Export/AgencyGroup/Agency/OrgId)"/>
        <xsl:element name="EXPORTRESPONSE" namespace="fieldpoint.com/namespaces">; <xsl:for-each select="//G1Export/BranchGroup">
          <xsl:if test="count(.) &gt; 0">
           <xsl:variable name="brnchOrgId" select="string(/G1Export/BranchGroup/BranchCode/OrgId)"/>        
           <!--Put the Branch information inside the current agency node only if branch belong to current Agency-->
           <xsl:if test="compare($brnchOrgId,$orgId)=0">asda
            <xsl:value-of select="'orgid is same as branchogid'"/>
           </xsl:if>
          </xsl:if>
         </xsl:for-each>
        </xsl:element>
       </xsl:if>
      </xsl:for-each>
     </xsl:element>
    </xsl:template>

Output:

<?xml version="1.0" encoding="UTF-8"?>
<PICRESPONSE xmlns="fieldpoint.com/namespaces">
    <EXPORTRESPONSE>; orgid is same as branchogid</EXPORTRESPONSE>
</PICRESPONSE>

Hope this helps.

Answer 2

Why not do AgencyGroup/Agency/OrgId = BranchGroup/BranchCode/OrgId? For extra anal, AgencyGroup/Agency/OrgId/text() = BranchGroup/BranchCode/OrgId/text().

If you need difference, consider AgencyGroup/Agency/OrgId - BranchGroup/BranchCode/OrgId

Answer 3

I don't know the context under which you need to compare these values, but the = operator is what you are looking for. This will compare them, but probably isn't the context you need:

<xsl:if 
  test="/G1Export/AgencyGroup/Agency/OrgId = /G1Export/BranchGroup/BranchCode/OrgId">