RE: Paging and Sorting

Play the video

Subject: RE: Paging and Sorting
From: "Katie McNally" <kmcnally9@xxxxxxxxxxx>
Date: Thu, 18 Oct 2001 08:47:20 -0500

I created the XSL below to transform XML to HTML for a Search Results page. On the Search Results page, the user must be able to sort each of the columns in the table of loans displayed, as well as page between results (10 loans are displayed on each page). The column title links as well as the paging links ("First Page", "Previous Page", "Next Page" and "Last Page") pass a query string that contains the column title that the table is being sorted by, the current upper limit, the action (link clicked) and the overall count of loans returned in the XSML. The logic in the servlet determines which link was clicked and and what the new upper and lower limits should be (which determines which set of 10 loans should be displayed). The name of the column that the table should be sorted by, the new lower limit and the new upper limit get passed to the XSL stylesheet as parameters.

I have the paging functionality working, but not the sorting. What do I need to do to do to include sorting cababilities when the user clicks on a column link? My XSL and XML are below.

XSL:

<?xml version='1.0'?>  <xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0'>

<xsl:param name="column">
</xsl:param>
<xsl:param name="lowerLimit" select="1">
</xsl:param>
<xsl:param name="upperLimit" select="10">
</xsl:param>

<xsl:template match='/'>

<xsl:variable name="counter">
<xsl:value-of select="count(ReturnResultSet/LoanSearchSet/Loan)"/>
</xsl:variable>

<table>

<tr>

<td> <a href="/loans/SearchResults.jsp?{'sort=LoanId&upperLimit=10&action=None'}{'&counter='}{$counter}"><b>Loan Number</b></a> </td>

<td>

<a href="/loans/SearchResults.jsp?{'sort=LastName&upperLimit=10&action=None'}{'&counter='}{$counter}"><b>Name</b></a> </td>

</tr>

<xsl:if test="$column='LoanId'"> <xsl:apply-templates select="ReturnResultSet/LoanSearchSet"> <xsl:sort select="ReturnResultSet/LoanSearchSet/Loan/LoanId" order="ascending"/> </xsl:apply-templates> </xsl:if>

<xsl:if test="$column='LastName'"> <xsl:apply-templates select="ReturnResultSet/LoanSearchSet"> <xsl:sort select="ReturnResultSet/LoanSearchSet/Loan/LoanBorrowerSet/Borrower/LastName" order="ascending"/> </xsl:apply-templates> </xsl:if>

</table>

<table>

<tr>

<td> <a href="/loans/SearchResults.jsp?{'sort='}{$column}{'&upperLimit='}{$upperLimit}{'&action=First'}{'&counter='}{$counter}"><b>First Page</b></a> </td>

<td> <xsl:if test="$lowerLimit > 1"> <a href="/loans/SearchResults.jsp?{'sort='}{$column}{'&upperLimit='}{$upperLimit}{'&action=Previous'}{'&counter='}{$counter}"><b>Previous Page</b></a> </xsl:if> </td>

<td> <xsl:if test="$counter > $upperLimit"> <a href="/loans/SearchResults.jsp?{'sort='}{$column}{'&upperLimit='}{$upperLimit}{'&action=Next'}{'&counter='}{$counter}"><b>Next Page</b></a> </xsl:if> </td>

<td>

<a href="/loans/SearchResults.jsp?{'sort='}{$column}{'&upperLimit='}{$upperLimit}{'&action=Last'}{'&counter='}{$counter}"><b>Last Page</b></a>

</td>

</tr>
</table>
</xsl:template>

<xsl:template match="ReturnResultSet/LoanSearchSet">

<xsl:apply-templates select="Loan[position() >= $lowerLimit and position() <= $upperLimit]"/> </xsl:template>

<xsl:template match="Loan[position() >= $lowerLimit and position() <= $upperLimit]">


 <tr>
 	  <td>
		  <xsl:variable name="loanid">
		  <xsl:value-of select='LoanId'/>
		  </xsl:variable>
		  <a href="/loans/LoanSummary.jsp?{$loanid}">
		  <xsl:value-of select='LoanId'/>
		  </a>
	  </td>

 	  <td>
	  	  <xsl:for-each select='LoanBorrowerSet/Borrower'>
		  <xsl:if test=\"Rank='1'\">
		  <xsl:value-of select='LastName'/>
		  </xsl:if>
		  </xsl:for-each>
	  </td>

</tr>

</xsl:template>

</xsl:stylesheet>

XML:

<ReturnResultSet>
	<LoanSearchSet>
		<Loan>
			<LoanId>123</LoanId>
			<LoanBorrowerSet>
				<Borrower>
					<LastName>Smith</LastName>
				</Borrower>
			</LoanBorrowerSet>
		</Loan>
		<Loan>
			<LoanId>456</LoanId>
			<LoanBorrowerSet>
				<Borrower>
					<LastName>Jones</LastName>
				</Borrower>
			</LoanBorrowerSet>
		</Loan>
		<Loan>
			<LoanId>789</LoanId>
			<LoanBorrowerSet>
				<Borrower>
					<LastName>Stills</LastName>
				</Borrower>
			</LoanBorrowerSet>
		</Loan>
		...
	</LoanSearchSet>
</ReturnResultSet>


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list

Current Thread

Re: Serializing external XML documents, (continued)
- Katie McNally - Mon, 8 Oct 2001 17:02:12 -0400 (EDT)
  - Chris Bayes - Mon, 8 Oct 2001 19:53:34 -0400 (EDT)
- Katie McNally - Thu, 18 Oct 2001 09:57:49 -0400 (EDT) <=
  - Jeni Tennison - Thu, 18 Oct 2001 11:29:26 -0400 (EDT)
  - Michael Kay - Thu, 18 Oct 2001 12:23:00 -0400 (EDT)
- Katie McNally - Thu, 18 Oct 2001 16:13:58 -0400 (EDT)
  - Mark Nahabedian - Thu, 18 Oct 2001 17:35:43 -0400 (EDT)

<- Previous	Index	Next ->
RE: Paging and Sorting, Chris Bayes	Thread	Re: Paging and Sorting, Jeni Tennison
Re: How do I remove the unnec, Mailer Mailer	Date	RE: recent benchmarks, advanc, DPawson
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >