XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » Dynamic Sorting with XSL
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> - XSLT slicing and orphan contro... (1)
-> + How to delete CDATA using XSL... (15)
-> + Remove only root namespace, bu... (3)
-> + String Parsing (3)
-> + Calling Java method from XSL (3)
-> + populate xsl file from xsd fil... (5)
-> + formating a number like #'###.... (3)
-> + Help with grouping children, f... (20)
-> + Need help for newbie! (3)
-> + xpath in string format (2)
-> + How to populate elements at ra... (4)
-> + Changing Date format in XLST (2)
-> + Please help....How could I rem... (2)
-> + Counting children and grandchi... (7)
-> + Nested tags (4)
-> + Problem with XSLT on a Soap En... (2)
-> + Problem with XSLT on a Soap En... (5)
-> + Comparison between XSLT proces... (2)
-> + Printing non-existing value (9)
-> + big input file for XSLT (14)
-> + Is there any way to store xpat... (2)
-> + Encoding special charecters (2)
-> + Sorting (3)
-> + XML to PDF using XSL:FO (3)
-> + How to find the line number in... (2)
-> + How to set a marker for paper ... (2)
-> + Not equality Function (2)
-> + Counting Elements (4)
-> + Looking for help or code samp... (2)
-> + Help needed in pattern matchin... (2)
-> + Repeaters and Ifs (2)
-> + select adjacent nodes in xpath... (3)
-> + Stripping of Empty Target Elem... (2)
-> + auto-generate Edifact Intercha... (5)
-> + Qname Error in xsl:element (2)
-> + [Newbie] Type conversion and f... (2)
-> + Do ...when (2)
-> + Using Key (3)
-> + sorting elements in option (2)
-> + NaN(not available) value repla... (3)
-> + infinite loop error when tryin... (9)
-> + Escape a character in the stri... (3)
-> + find sum of 2 elements in xml (2)
-> + placing a ' * ' by reading the... (3)
-> + Problem in dispaying Current D... (4)
-> + Merging Table Cells in XSLT re... (3)
-> + xsl fo block-container and foo... (2)
-> + Is is possible to create a .CO... (2)
-> + printing a parent node value i... (2)
-> + Mime header info setup? (3)
-> + Calculating a Date based on 4 ... (3)
-> + XSLT formatting number issue (10)
-> + map repeating elements separat... (3)
-> + Combining XML elements based o... (3)
-> + Convert XML to UTF-8 (8)
-> + XSLT and MS Access 2007 Optio... (5)
-> - WORDML list to XML list (1)
-> + [Newbie] Using lookups in XSLT... (3)
-> + Comparing 2 passed Date Values (2)
-> + ERROR XQueryMediator Error du... (2)
-> + XML / XSLT... Unordered lists ... (2)
-> + Specify image path in XSL (2)
-> + Variable within a variable (3)
-> + How to call jfreechart method ... (8)
-> + leading and trailing white spa... (2)
-> + XSLT to Html problems (6)
-> + How to set classpath, when i n... (3)
-> + Error in using functions (4)
-> + To find the occurence of a cha... (3)
-> + PLMXML to XML (4)
-> + Transform multiple node values... (2)
-> + I am in need of svg example(s)... (13)
-> + count in XSLT, Need Help Pleas... (2)
-> + Help with XML.Report and Gener... (2)
-> + for each loop and variable (5)
-> + Problem with selecting nodes f... (3)
-> + Getting "Expected elemenmt mis... (2)
-> + Help with attached XML mapping... (8)
-> + xml:space="Preserve" and Embed... (2)
-> + XSLT and Multiple Strings (2)
-> + XSL Date format (2)
-> + check element contents against... (3)
-> + XML to XML Namespace conversio... (2)
-> - Supressing subgroup headers in... (1)
-> - HTML to fo conversion using XS... (1)
-> + No Topic (2)
-> + parsing xml using xslt HELP (2)
-> + Multiple Page Headers (2)
-> + PLM Xml To Generic XML (3)
-> + XSLT/XPath Help (2)
-> + XSL Space Issue (2)
-> + wanting help with xslt custom ... (3)
-> - Update input xml content with ... (1)
-> + Error: namespace prefix xsl on... (3)
-> + Error in my xsl:if test... (2)
-> - calling javascript from XSLT (1)
-> + Error when trying to a call a ... (2)
-> - HTTP POST from XSLT (1)
-> + passing xml document as input ... (2)
-> + XSLT for WORDML table to CALS ... (2)
-- Previous [361-380] [381-400] [401-420] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Shaunna SheltonSubject: Dynamic Sorting with XSL
Author: Shaunna Shelton
Date: 11 May 2005 06:33 PM
I have the following XSL stylesheet transforming an XML file. This is being done via ColdFusion which utilizes Xalan, as I understand it.

The sorting is harcoded, but I need to figure out how to make it dynamic - so that when a user clicks one of the headings (File Name, Author, etc) it will sort the data by whatever option they chose. I understand you must declare a parameter and then test for the parameter's value, but am not sure of the syntax. I would be passing the parameter in a query string like so, ?sortby=FileName.

Any direction is much appreciated:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="html" />

<xsl:template match="/documents" >
<html>
<head><title>Master List</title></head>
<body>
<div class="TableContainer">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="ContentTable">
<tr>
<td class="ContentTitle" colspan="6">Documents</td>
</tr>
<tr>
<th><a href="displayXML.cfm?sortby=FileName">File Name</a></th>
<th><a href="displayXML.cfm?sortby=Created">Created</a></th>
<th><a href="displayXML.cfm?sortby=Modified">Last Modified</a></th>
<th><a href="displayXML.cfm?sortby=Title">Title</a></th>
<th><a href="displayXML.cfm?sortby=Author">Original Author</a></th>
<th><a href="displayXML.cfm?sortby=Editor">Last Editor</a></th>
</tr>
<xsl:for-each select="document">
<xsl:sort select="Author" />
<tr>
<td><xsl:value-of select="@FILENAME" /></td>
<td><xsl:value-of select="Creation_date" /></td>
<td><xsl:value-of select="@MODIFIEDDATE" /></td>
<td><xsl:value-of select="Title" /></td>
<td><xsl:value-of select="Author" /></td>
<td><xsl:value-of select="Last_author" /></td>
</tr>
</xsl:for-each>
</table>
</div>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
Postnext
Ivan PedruzziSubject: Dynamic Sorting with XSL
Author: Ivan Pedruzzi
Date: 12 May 2005 06:57 PM
Hi Shaunna

You can get close to what you have described with the following solution.
Test the XSLT with the books.xml sample to see how it works.

Hope this Helps
Ivan Pedruzzi
Stylus Studio Team

<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:param name="sort-by" select="'title'"/>

<xsl:template match="/">
<root>
<xsl:for-each select="books/book">
<xsl:sort select="*[local-name() = $sort-by]"/>
<xsl:element name="{$sort-by}">
<xsl:value-of select="*[local-name() = $sort-by]"/>
</xsl:element>
</xsl:for-each>
</root>
</xsl:template>

</xsl:stylesheet>
Posttop
Shaunna SheltonSubject: Dynamic Sorting with XSL
Author: Shaunna Shelton
Date: 13 May 2005 10:44 AM
I came up with this last night after reading a tutorial here: http://pascal.soulshine.de/projects/articles/xsl_table/

However, thought it looks correct to me, it's still not sorting for some reason. Can anyone see anything obviously wrong?


<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" />

<xsl:param name="smode" />

<xsl:template match="documents">
<html>
<head>
<title>Documents</title>
</head>
<body>
<xsl:call-template name="document" />
</body>
</html>
</xsl:template>

<xsl:template name="sorting">
<xsl:choose>
<xsl:when test="contains($smode, 'FileName')">
<xsl:apply-templates>
<xsl:sort select="@FILENAME" order="descending" />
</xsl:apply-templates>
</xsl:when>
<xsl:when test="contains($smode, 'Created')">
<xsl:apply-templates>
<xsl:sort select="Creation_date" order="descending" />
</xsl:apply-templates>
</xsl:when>
<xsl:when test="contains($smode, 'Modified')">
<xsl:apply-templates>
<xsl:sort select="@MODIFIEDDATE" order="descending" />
</xsl:apply-templates>
</xsl:when>
<xsl:when test="contains($smode, 'Title')">
<xsl:apply-templates>
<xsl:sort select="Title" order="descending" />
</xsl:apply-templates>
</xsl:when>
<xsl:when test="contains($smode, 'Author')">
<xsl:apply-templates>
<xsl:sort select="Author" order="descending" />
</xsl:apply-templates>
</xsl:when>
<xsl:when test="contains($smode, 'Editor')">
<xsl:apply-templates>
<xsl:sort select="Last_Author" order="descending" />
</xsl:apply-templates>
</xsl:when>
<xsl:otherwise>
<xsl:apply-templates />
</xsl:otherwise>
</xsl:choose>
</xsl:template>


<xsl:template name="document">
<div class="TableContainer">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="ContentTable">
<tr>
<td class="ContentTitle" colspan="6">Documents</td>
</tr>
<tr>
<th><a href="displayXML.cfm?sortby=FileName">File Name</a></th>
<th><a href="displayXML.cfm?sortby=Created">Created</a></th>
<th><a href="displayXML.cfm?sortby=Modified">Last Modified</a></th>
<th><a href="displayXML.cfm?sortby=Title">Title</a></th>
<th><a href="displayXML.cfm?sortby=Author">Original Author</a></th>
<th><a href="displayXML.cfm?sortby=Editor">Last Editor</a></th>
</tr>
<tbody>
<xsl:call-template name="sorting" />
</tbody>
</table>
</div>
</xsl:template>

<xsl:template match="document" name="srow">
<tr>
<td><xsl:value-of select="current()/@FILENAME" /></td>
<td><xsl:value-of select="current()/Creation_date" /></td>
<td><xsl:value-of select="current()/@MODIFIEDDATE" /></td>
<td><xsl:value-of select="current()/Title" /></td>
<td><xsl:value-of select="current()/Author" /></td>
<td><xsl:value-of select="current()/Last_author" /></td>
</tr>

</xsl:template>
</xsl:stylesheet>

Ivan, thanks for the tip. I'll have to try and see if I can get your method to work if I can't get this functioning.


DocumentdocumentXML.xml
XML document
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.