<div>
sort all the records using SQL and then select required records using ROWNUM in oracle
</div>


sort all the records using SQL and then select required records using ROWNUM in oracle

<div>
<div class="content wysiwyg-content">
I'm using the JSP Display tag library (website is <a href="http://displaytag.sourceforge.net/1.2/" rel="ugc">http://displaytag.sourceforge.net/1.2/</a>). I have pagesize set to 30. &nbsp;I have a total of 280 records. &nbsp;Therefore, the tables displayed have pagination (Next page, first, previous, 1, 2, 3, etc.). &nbsp;I have sorting enabled. &nbsp;The problem is that sorting is performed on a per page basis. &nbsp;<br />
<br />
One of the users &nbsp;would like to see sorting on ALL records WITH pagination. &nbsp;That is sort all records when click on column. &nbsp;When click Next page, sorting order is maintained.<br />
<br />
Any ideas from Display Tag users?
</div>
</div>


I'm using the JSP Display tag library (website is http://displaytag.sourceforge.net/1.2/). I have pagesize set to 30.  I have a total of 280 records.  Therefore, the tables displayed have pagination (Next page, first, previous, 1, 2, 3, etc.).  I have sorting enabled.  The problem is that sorting is performed on a per page basis.  

One of the users  would like to see sorting on ALL records WITH pagination.  That is sort all records when click on column.  When click Next page, sorting order is maintained.

Any ideas from Display Tag users?

Display Tag JSP Sorting Issue

Java Enterprise Edition (Java EE) is a specification defining a collection of Java-based server and client technologies and how they interoperate. Java EE specifies server and client architectures and uses profiles to define technology sets targeted at specific classes of applications. All Java EE profiles share a set of common features, such as naming and resource injection, packaging rules and security requirements.

Java EE

JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.

HTML (HyperText Markup Language) is the main markup language for creating web pages and other information to be displayed in a web browser, providing both the structure and content for what is sent from a web server through the use of tags. The current implementation of the HTML specification is HTML5.