1 Reply Latest reply: Aug 12, 2014 9:06 PM by user575360 RSS

    Usage of Document function in xslt

    Tarak

      Hello All,

       

      I want to lookup xml file and retrieve the value based on key in xslt. .

       

      Below is the xml file

       

      <?xml version="1.0" encoding="UTF-8"?>

       

      <mm:ValueMaps

          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

          xmlns:mm="http://WCToSSFSMediationModule"

      >

          <mm:Map name="storeIdToOrganizationCode">  

              <mm:Entry key="19658">001GB</mm:Entry>

              <mm:Entry key="11306">001CA</mm:Entry>

        </mm:Map>

      </mm:ValueMaps>

       

      Below the xpath i have used in document function in xslt and but my bad its not working. Could some please help me in figuring it out pls

       

       

      <xsl:variable name="actualOrganizationCode"

                          select="document(&quot;Maps.xml&quot;,&quot;mm:ValueMaps/mm:Map[@name='storeIdToOrganizationCode']/mm:Entry[@key=$storeId]/text()&quot;)"/>

       

      "storeId" is a variable that hold value in xslt which i am using in document function.

       

      FYI Maps.xml is located under same directory of xslt.

       

       

      Regards,

      Tarak.