CODEWITHSUNDEEP
xmlsortingxsltnested
Andres Bota
Andres Bota

Reputation: 11

XSL nested SORT issue

I need to show the result of two nested FOR-EACHs showing all the results of both in alphabetic order I tried to use a node-set but it doesn't work. How can I Sort all the result of both For-Each?

data: 

<?xml version="1.0" encoding="UTF-8"?>
<list>
<catalog>
  <cd>
    <title>Empire Burlesque</title>
    <artist>Bob Dylan</artist>
    <country>USA</country>
    <company>Columbia</company>
    <price>10.90</price>
    <year>1985</year>
  </cd>
  <cd>
    <title>Hide your heart</title>
    <artist>Bonnie Tyler</artist>
    <country>UK</country>
    <company>CBS Records</company>
    <price>9.90</price>
    <year>1988</year>
  </cd>
  <cd>
    <title>Greatest Hits</title>
    <artist>Dolly Parton</artist>
    <country>USA</country>
    <company>RCA</company>
    <price>9.90</price>
    <year>1982</year>
  </cd>

</catalog>
<catalog>  
<cd>
    <title>When a man loves a woman</title>
    <artist>Zercy Sledge</artist>
    <country>USA</country>
    <company>Atlantic</company>
    <price>8.70</price>
    <year>1987</year>
  </cd>
  <cd>
    <title>Black angel</title>
    <artist>Avage Rose</artist>
    <country>EU</country>
    <company>Mega</company>
    <price>10.90</price>
    <year>1995</year>
  </cd>
  <cd>
    <title>1999 Grammy Nominees</title>
    <artist>Iany</artist>
    <country>USA</country>
    <company>Grammy</company>
    <price>10.20</price>
    <year>1999</year>
  </cd>

</catalog>

</list>

Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

 <xsl:template match="/">
  <html>
  <body>
     <h2>My CD Collection</h2>
  <table border="1">
    <tr bgcolor="#9acd32">
      <th>Title</th>
      <th>Artist</th>
    </tr>
    <xsl:for-each select="list/catalog">
 <xsl:for-each select="cd">
      <xsl:sort select="artist"/>
     <tr>
      <td><xsl:value-of select="title"/></td>
    <td><xsl:value-of select="artist"/></td>
  </tr>
  </xsl:for-each>
</xsl:for-each>
    </table>
  </body>
  </html>
</xsl:template>

</xsl:stylesheet>

Result: Result: Expected: Expected:

Upvotes: 0

Views: 48

Answers (1)

michael.hor257k
michael.hor257k

Reputation: 116993

You are sorting each catalog separately. To sort all cds together, regardless of their catalog, do simply:

<xsl:template match="/">
    <html>
        <body>
        <h2>My CD Collection</h2>
        <table border="1">
            <tr bgcolor="#9acd32">
                <th>Title</th>
                <th>Artist</th>
            </tr>
            <xsl:for-each select="list/catalog/cd">
                <xsl:sort select="artist"/>
                <tr>
                    <td><xsl:value-of select="title"/></td>
                    <td><xsl:value-of select="artist"/></td>
                </tr>
            </xsl:for-each>
        </table>
        </body>
    </html>
</xsl:template>

Upvotes: 1

Related Questions