XML - XSLT - number and sort

Question

I want to sort my xml data and also number them. Here is for example xml code:

  <images>
      <image>
        <title>cat</title>
        <grade>3</grade>
      </image>
      <image>
        <title>dog</title>
        <grade>5</grade>
      </image>
      <image>
        <title>snake</title>
        <grade>1</grade>
      </image>
      <image>
        <title>fish</title>
        <grade>2</grade>
      </image>
   </images>

and xslt code:

  <xsl:template match="images">
    <xsl:for-each select="image">
      <xsl:sort select="grade"/>
      <tr>
        <td>
          <xsl:number/>
        </td>
        <td>
          <xsl:value-of select="title"/>
        </td>
        <td>
          <xsl:value-of select="grade"/>
        </td>
      </tr>
    </xsl:for-each>
  </xsl:template>

The result of this is:

3 cat  1
4 fish 2
1 cat  3
2 dog  5

And i would like to have:

1 cat  1
2 fish 2
3 cat  3
4 dog  5

How can I make this in a simple way?

Tim C · Accepted Answer · 2016-01-15 11:54:20Z

2

Instead of using <xsl:number /> do this instead

 <xsl:value-of select="position()" />

position() will return the position of the node in the selected node-set after it has been sorted (as opposed to the position of the node in the hierarchy).

answered Jan 15, 2016 at 11:54

Tim C

70.7k14 gold badges77 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

fafl · Accepted Answer · 2016-01-15 11:55:40Z

1

xsl:number is good, but you need the current position. Also you should sort by numeric value:

<xsl:template match="images">
    <xsl:for-each select="image">
      <xsl:sort select="number(grade)"/>
      <tr>
        <td>
          <xsl:number value="position()"/>
        </td>
        <td>
          <xsl:value-of select="title"/>
        </td>
        <td>
          <xsl:value-of select="grade"/>
        </td>
      </tr>
    </xsl:for-each>
</xsl:template>

answered Jan 15, 2016 at 11:55

fafl

7,5074 gold badges32 silver badges54 bronze badges

1 Comment

michael.hor257k Over a year ago

<xsl:sort select="number(grade)"/> That would work in XSLT 2.0, but not in XSLT 1.0. <xsl:sort select="grade" data-type="number"/> would work for both.

Collectives™ on Stack Overflow

XML - XSLT - number and sort

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related