Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

XML Sort on attribute using xsl:sort

Posted on 2009-07-04
6
Medium Priority
?
405 Views
Last Modified: 2013-11-19
Hi,
I need to sort an xml document by an attribute. I am unable to do this by using the attached xsl stylesheet. Please help.

I need to sort the below document (dataField Nodea) by it's Table_Id attribute

As I said the above xslt does not work for sorting on Table_Id attribute, although the same thing works for Node_Id attribute if I just replace "DataField/@Table_Id" with "DataField/@Node_Id" in xslt. I am completely baffled by it's behavior. I am using VB6 (I think that should not matter).

I am very concerned as to why it works with one field and not the other.

Any help with some explaination is greatly appreciated.

Thanks in advance
My xml document
-----------------------------
<SubCompetency Node_Id = "3" Node_Name = "SubComp1">
    <DataField
        Table_Id = "14"
        Node_Id = "13"
        Node_Name = "Data1"
        ReqToCmp = "1"
        Def_Val = "NULL">
        <HtmField Node_Id = "16" Node_Name = "Field1">
            <HtmGrpField
                Node_Id = "79"
                Node_Name = "Grp1"
                Node_Val = "5"/>
            <HtmGrpField
                Node_Id = "80"
                Node_Name = "Grp2"
                Node_Val = "4"/>
            <HtmGrpField
                Node_Id = "81"
                Node_Name = "Grp3"
                Node_Val = "3"/>
            <HtmGrpField
                Node_Id = "82"
                Node_Name = "Grp4"
                Node_Val = "2"/>
            <HtmGrpField
                Node_Id = "83"
                Node_Name = "Grp5"
                Node_Val = "1"/>
            <HtmGrpField
                Node_Id = "84"
                Node_Name = "Grp6"
                Node_Val = "0"/>
        </HtmField>
    </DataField>
    <DataField
        Table_Id = "8"
        Node_Id = "25"
        Node_Name = "Data2"
        ReqToCmp = "1"
        Def_Val = "NULL">
        <HtmField Node_Id = "28" Node_Name = "Field2">
            <HtmGrpField
                Node_Id = "151"
                Node_Name = "Grp1"
                Node_Val = "5"/>
            <HtmGrpField
                Node_Id = "152"
                Node_Name = "Grp1"
                Node_Val = "4"/>
            <HtmGrpField
                Node_Id = "153"
                Node_Name = "Grp1"
                Node_Val = "3"/>
            <HtmGrpField
                Node_Id = "154"
                Node_Name = "Grp4"
                Node_Val = "2"/>
            <HtmGrpField
                Node_Id = "155"
                Node_Name = "Grp5"
                Node_Val = "1"/>
            <HtmGrpField
                Node_Id = "156"
                Node_Name = "Grp6"
                Node_Val = "0"/>
        </HtmField>
    </DataField>
    <DataField
        Table_Id = "3"
        Node_Id = "26"
        Node_Name = "Data3"
        ReqToCmp = "1"
        Def_Val = "NULL">
        <HtmField Node_Id = "29" Node_Name = "Field3">
            <HtmGrpField
                Node_Id = "157"
                Node_Name = "Grp1"
                Node_Val = "5"/>
            <HtmGrpField
                Node_Id = "158"
                Node_Name = "Grp2"
                Node_Val = "4"/>
            <HtmGrpField
                Node_Id = "159"
                Node_Name = "Grp3"
                Node_Val = "3"/>
            <HtmGrpField
                Node_Id = "160"
                Node_Name = "Grp4"
                Node_Val = "2"/>
            <HtmGrpField
                Node_Id = "161"
                Node_Name = "Grp5"
                Node_Val = "1"/>
            <HtmGrpField
                Node_Id = "162"
                Node_Name = "Grp6"
                Node_Val = "0"/>
        </HtmField>
    </DataField>
</SubCompetency>
------------------------------------------------------
 
My Xsl stylesheet
---------------------------------------------------------
 
<?xml version="1.0" encoding="UTF-8"?>"
    <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">"
    <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>"
    <xsl:template match="SubCompetency|@*">"
    <xsl:copy><xsl:apply-templates select="node()|@*">"
    <xsl:sort select="DataField/@Table_Id" data-type="number" order="descending"/>"
    </xsl:apply-templates></xsl:copy></xsl:template>"
    <xsl:template match="node()|@*"><xsl:copy><xsl:apply-templates select="node()|@*"/>"
    </xsl:copy></xsl:template></xsl:stylesheet>"
--------------------------------------------------------------

Open in new window

0
Comment
Question by:Bagur
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24779667
I think that it should not work with @Node_Id either
You are nesting one element too deep
<xsl:sort select="DataField/@Table_Id"
should be
<xsl:sort select="@Table_Id"
I think that nodes are incidently preorderd on Node_Id, because it should not have worked

There are some issues with ambiguous templates for @*,
I rearranged you stylesheet a bit, see below
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
    <xsl:template match="SubCompetency">
        <xsl:copy>
            <xsl:copy-of select="@*"/>
            <xsl:apply-templates select="node()">
                <xsl:sort select="@Table_Id" data-type="number" order="descending"/>
            </xsl:apply-templates>
        </xsl:copy>
    </xsl:template>
    <xsl:template match="node()">
        <xsl:copy>
            <xsl:copy-of select="@*"/>
            <xsl:apply-templates select="node()"/>
        </xsl:copy>
    </xsl:template>
</xsl:stylesheet>

Open in new window

0
 

Author Comment

by:Bagur
ID: 24781371
Hi Gertone,

The solution worked, gr8.., but I still need to understand 2 more things

a) The @Node_Id was not ordered incidentally, I made sure of that and the sort works for @Node_Id

b) Why do you say that it is ordered one element deep? I am naive to this, so please explain how. I thought since we are matching subCompetency node, the DataField/@Table_Id falls directly underneath subCompetency Node and it should work fine. Anyway, the @Table_Id is an attribute of DataField, so what's wrong with mentioning DataField/@Table_Id? I know it does not work like that, but please explain how/why.

Thanks.
0
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 2000 total points
ID: 24781379
You are right that the template is on subCompentency,
in there you state
            <xsl:apply-templates select="node()">
                <xsl:sort select="@Table_Id" data-type="number" order="descending"/>
            </xsl:apply-templates>
The node() in this case is the child elements (so one level deep), including DataField
So you are pushing the DataField nodes to the templates and those DataField nodes you want to sort.
The sort select XPath starts from the nodes mentioned in the select on the apply-templates
So, what you really want is sorting on the @Table_id of the DataField
... you want to sort
DataField on
subCompetency/DataField/@Table_id
and not on
subCompetency/DataField/DataField/@Table_id
that was your error.
You lost sight of the context awareness of the XPath
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24781385
about your a)
 DataField/@Node_Id can not work,
likely you had put
 @Node_Id
0
 

Author Closing Comment

by:Bagur
ID: 31599861
Thank you very much for the detailed explaination!
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24781398
welcome
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
The viewer will learn how to dynamically set the form action using jQuery.
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question