sorting issue

nguna · July 28th, 2009, 07:33 AM

I am trying to sort an xml file except one particular node which should always appear on the top.

Example input xml

<Data>
<object>1</object>
<a></a>
<c></c>
<l>

nguna · July 28th, 2009, 07:39 AM

sorry didn't post the question in full.

Input xml

<Data>
<object>1</object>
<agent>C</agent>
<productCode>S</productCode>
<dateRequired>0</dateRequired>
<paymentMethod>
<object>131</object>
<paymentTypeId/>
<numberOfInstallments>0</numberOfInstallments>
</paymentMethod>
</Data>

Output xml should be

<Data>
<object>1</object>
<agent>C</agent>
<dateRequired>0</dateRequired>
<paymentMethod>
<object>131</object>
<numberOfInstallments>0</numberOfInstallments>
<paymentTypeId/>
</paymentMethod>
<productCode>S</productCode>
</Data>

all the nodes should be sorted except objectID

any ideas ?

Thanks

Martin Honnen · July 28th, 2009, 07:39 AM

Consider to post some sample input XML and the corresponding output XML you want the stylesheet to create.
That "example input xml" you have shown is too short and has nothing but one element with data (<object>1</object>) that at least I have no idea which data you want to sort and which not.

Martin Honnen · July 28th, 2009, 07:45 AM

Here is a sample stylesheet that sorts all child elements except the 'object' element on the element name:

Code:

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  version="1.0">
  
  <xsl:output indent="yes"/>
  
  <xsl:template match="*[*]">
    <xsl:copy>
      <xsl:copy-of select="object"/>
      <xsl:apply-templates select="*[not(self::object)]">
        <xsl:sort select="name()"/>
      </xsl:apply-templates>
    </xsl:copy>
  </xsl:template>
  
  <xsl:template match="*[not(*)]">
    <xsl:copy-of select="."/>
  </xsl:template>

</xsl:stylesheet>