XSL sort in component is not working

I'm trying to sort out the ids from all DCR nodes under the templatedata, but it doesn't work by sorting in ascending order.

Here's my code -

<!DOCTYPE html-entities SYSTEM "http://www.interwoven.com/livesite/xsl/xsl-html.dtd">
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:include href="http://www.interwoven.com/livesite/xsl/HTMLTemplates.xsl"/>
<xsl:include href="http://www.interwoven.com/livesite/xsl/StringTemplates.xsl"/>

<xsl:template match="/">
<xsl:apply-templates select="//ContentList/child::node()">
</xsl:apply-templates>
</xsl:template>

<xsl:template match="//ContentList/child::node()">

<xsl:variable name="ServerVar"><xsl:value-of select="@serverURL"/>/<xsl:value-of select="@VPath"/></xsl:variable>
<xsl:variable name="VPath"><xsl:value-of select="@VPath"/></xsl:variable>
<xsl:if test = "contains ($ServerVar,'templatedata/Site1/data/')" >

<xsl:variable name="NewVarObj" select="document($ServerVar)"/>
<xsl:for-each select="$NewVarObj/item/container">

<xsl:sort select="id" data-type="number" order="ascending"/>
    <br/><xsl:value-of select="id"/>
  </xsl:for-each>
    </xsl:if>
</xsl:template>
</xsl:stylesheet>

Does anyone share some advice on this issue?

Thanks.

Find more posts tagged with

Comments

David Smith

well what is it doing?

Pauliw

When you say " it doesn't work by sorting in ascending order" , Does it mean, you are able to get the result for <xsl:value-of select="ID"/> ? , or nothing is displayed.

Thanks
Paul

mm1

I can display the IDs on the web page but not sorted by ID order.

mm1

20150725
20150804
20150721
20150727

It should be
20150721
20150725
20150727
20150804

In ascending order.
IDs are numeric.

Adam Stoller

If you post a sample of the XML file(s?) being processed by that XSL - I *might* find some time to play with it...

mm1

Here are the 4 DCRs. NOTE: Typo error on my <xsl:value-of select="ID"/> above message.

It's <xsl:value-of select="id"/>, tried this but not working with the xsl sort function.

1. DCR file = templatedata/Site1/data/20150725

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

2. DCR file = templatedata/Site1/data/20150804

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

3. DCR file = templatedata/Site1/data/20150721

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

4. DCR file = templatedata/Site1/data/20150727

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

Anil Kumar

try adding number function

<xsl:sort select="number(id)" data-type="number" order="ascending"/>

mm1

@aneelgkumar - it didn't work and the page is blank.

Pauliw

This works for me

<xsl:sort select="number(.)" data-type="number" order="asecending"/>
<br/>
<xsl:value-of select="."/>

Bowker

Are you trying to sort the values coming back from the four separate DCRs?

Maybe I misunderstand what you're doing but it looks like you are reading from four different DCRs then trying to sort one node within that DCR.

My guess if you add: <xsl:value-of select="position()"/> after you write out the id, you will get position 1 for each value.

You will need to combine the four DCRs into a one tree (treefrag?) then for-each over that.