David,

Thanks so much for the quick response, however, that did not work.  Here is 
what I'm seeing when I first go in and then look below what I'm seeing after I 
click the REQ # title.  Just weird to me.  I know it is some kind of setting.  
I just don't know what else it could be.

Here is an example of the REQ # order that I see when I first come into the 
page :

106  8681 8681  8681 A MONTGJE MONTGJE STK   
107  8681 8681  8681 A MONTGJE MONTGJE STK   
108  8681 8681  8681 A MONTGJE MONTGJE STK   
109  SPLT SPLT  8681 A MONTGJE SAVOYM STK   
110  8681 8681  8681 A MONTGJE MONTGJE STK   
111  8681 8681  8681 A MONTGJE MONTGJE STK   
112  8681 8681  8681 A MONTGJE MONTGJE STK   
113  8681 8681  8681 A MONTGJE MONTGJE STK   
114  8681 8681  8681 A MONTGJE MONTGJE STK   
115  8681 8681  8681 A MONTGJE MONTGJE STK   
116  8681 8681  8681 A MONTGJE MONTGJE STK   
117  8681 8681  8681 A MONTGJE MONTGJE STK   
118  8681 8681  8681 A MONTGJE MONTGJE STK   
119  8681 8681  8681 A MONTGJE MONTGJE STK   
120  8681 8681  8681 A MONTGJE MONTGJE STK   
121  8681 8681  8681 A MONTGJE MONTGJE STK   
122  8681 8681  8681 A MONTGJE MONTGJE STK   
123  8681 8681  8681 A MONTGJE MONTGJE STK   
124  8681 8681  8681 A MONTGJE MONTGJE STK   
125  8681 8681  8681 A MONTGJE MONTGJE STK   
126  8681 8681  8681 A MONTGJE MONTGJE STK   
127  8681 8681  8681 A MONTGJE MONTGJE STK   
128  8681 8681  8681 A MONTGJE MONTGJE STK   
129  8681 8681  8681 A MONTGJE MONTGJE STK   
130  8681 8681  8681 A MONTGJE MONTGJE STK   
131  8681 8681  8681 A MONTGJE MONTGJE STK   
132  8681 8681  8681 A MONTGJE MONTGJE STK   
133  8681 8681  8681 A MONTGJE MONTGJE STK   
134  8681 8681  8681 A MONTGJE MONTGJE STK   
135  8681 8681  8681 A MONTGJE MONTGJE STK   
136  8681 8681  8681 A MONTGJE MONTGJE STK   
137  8681 8681  8681 A MONTGJE MONTGJE STK   
138  8681 8681  8681 A MONTGJE MONTGJE STK   
139  8681 8681  8681 A MONTGJE MONTGJE STK   
140  8681 8681  8681 A MONTGJE MONTGJE STK   
141  8681 8681  8681 A MONTGJE MONTGJE STK   
142  8681 8681  8681 A MONTGJE MONTGJE STK   
143  8681 8681  8681 A MONTGJE MONTGJE STK   
144  8681 8681  8681 A MONTGJE MONTGJE STK   
145  8681 8681  8681 A MONTGJE MONTGJE STK   
146  8681 8681  8681 A MONTGJE MONTGJE STK   
147  8681 8681  8681 A MONTGJE MONTGJE STK   
148  8681 8681  8681 A MONTGJE MONTGJE STK   
149  8681 8681  8681 A MONTGJE MONTGJE STK   
150  8681 8681  8681 A MONTGJE MONTGJE STK   
151  8681 8681  8681 A MONTGJE MONTGJE STK   
152  8681 8681  8681 A MONTGJE MONTGJE STK   
153  8681 8681  8681 A MONTGJE MONTGJE STK   
154  8681 8681  8681 A MONTGJE MONTGJE STK   
155  8681 8681  8681 A MONTGJE MONTGJE STK 

In the last page of 4 pages I have REQ # order of (PLEASE NOTE:  40002027 comes 
after 40002097(WHY?)):

40002026  8681 8681  8681 O CDPPKRB PURCHASING STK   
40002028  8681 8681  8681 I CDPPKRB CDPPKRB STK   
40002049  8681 8681  8681 A CDPPKRB SAVOYM STK   
40002058  8681 8681  8681 O CDPPKRB PURCHASING STK   
40002059  8681 8681  8681 S CDPPKRB  INV CKF5040L 304522258 
 Desc: CATH KIT PEDI 5FR 
40002060  8681 8681  8681 A CDPPKRB SAVOYM STK   
40002091  8681 8681  8681 A MONTGJE MONTGJE CRN 1  
 Desc: CREDIT REQUISITION 
40002092  8681 8681  8681 S MONTGJE  CRS 42268 304582186 
 Desc: BLANKET WARMING UPPER BODY WHT 
40002093  8681 8681  8681 S MONTGJE  INV 45218 304510259 
 Desc: DIAPER INFANT SZ4 21-37# 
40002094  6000 7000 8681 8681 S MONTGJE  CRL 2B8071 304586542 
 Desc: ADAPTER VIAL-MATE 
40002095  8681 8681 8681 8681 S MONTGJE  CRL 2B8071 304586542 
 Desc: ADAPTER VIAL-MATE 
40002096  8681 8681  8681 S MONTGJE  CRS JJ3150 304584788 
 Desc: DRSNG BIOPATCH 1X4.0MM DISK 
40002097  8681 8681  8681 S MONTGJE  INV JJ1953 304502756 
 Desc: DRSNG SURGICEL HEMOSTAT 2X3 
40002027 440000095 8681 8681  8681 O CDPPKRB  INV 42268 304582186 

After I click the REQ # column title name on the first page (No particular 
order(?)):

40002027 440000095 8681 8681  8681 O CDPPKRB  INV 42268 304582186 
 Desc: BLANKET WARMING UPPER BODY WHT 
40002059  8681 8681  8681 S CDPPKRB  INV CKF5040L 304522258 
 Desc: CATH KIT PEDI 5FR 
40002093  8681 8681  8681 S MONTGJE  INV 45218 304510259 
 Desc: DIAPER INFANT SZ4 21-37# 
40002097  8681 8681  8681 S MONTGJE  INV JJ1953 304502756 
 Desc: DRSNG SURGICEL HEMOSTAT 2X3 
40002092  8681 8681  8681 S MONTGJE  CRS 42268 304582186 
 Desc: BLANKET WARMING UPPER BODY WHT 
40002096  8681 8681  8681 S MONTGJE  CRS JJ3150 304584788 
 Desc: DRSNG BIOPATCH 1X4.0MM DISK 
40002094  6000 7000 8681 8681 S MONTGJE  CRL 2B8071 304586542 
 Desc: ADAPTER VIAL-MATE 
40002095  8681 8681 8681 8681 S MONTGJE  CRL 2B8071 304586542 
 Desc: ADAPTER VIAL-MATE 
228  8681 8681  6700 A MONTGJE SAVOYM NST 12345  
 Desc: NST TEST 
229  8681 8681  8681 A MONTGJE MONTGJE NST 56789  
 Desc: NST W/ PHI 
230  8681 8681  8681 A MONTGJE MONTGJE NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
231  8681 8681  8681 A MONTGJE SMITHED NST 12345  
 Desc: NST TEST 
232  8681 8681  8681 A MONTGJE MONTGJE NST 56789  
 Desc: NST W/ PHI 
233  8681 8681  8681 A MONTGJE MONTGJE NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
234  8681 8681  8681 A MONTGJE SMITHED NST 12345  
 Desc: PRINT NOTE TEST 
235  8681 8681  8681 A MONTGJE MONTGJE NST 56789  
 Desc: NST W/ PHI 
236  8681 8681  8681 A MONTGJE MONTGJE NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
237  8681 8681  8681 A MONTGJE SAVOYM NST 12345  
 Desc: MULTIPLE R-NOTES 
238  8681 8681  8681 A MONTGJE MONTGJE NST 56789  
 Desc: NST W/ PHI 
239  8681 8681  8681 A MONTGJE MONTGJE NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
240  8681 8681  8681 A MONTGJE SAVOYM NST 12345  
 Desc: NST TEST 
241  8681 8681  8681 A MONTGJE MONTGJE NST 56789  
 Desc: NST W/ PHI 
242  8681 8681  8681 A MONTGJE MONTGJE NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
243  SPLT SPLT  8681 A MONTGJE SAVOYM NST 12345  
 Desc: NST TEST 
244  8681 8681  8681 S MONTGJE PURCHASING NST 56789  
 Desc: NST W/ PHI 
245  8681 8681  8681 S MONTGJE PURCHASING NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
246  8681 8681  8681 S MONTGJE PURCHASING NST 12345  
 Desc: NST TEST 
247  8681 8681  8681 A JUST4U MONTGJE NST 12345  
 Desc: NST SPLT TEST 
248  8681 8681  8681 A MONTGJE SAVOYM NST 56789  
 Desc: NST W/ PHI 
249  8681 8681  8681 A MONTGJE SAVOYM NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
250  8681 8681  8681 A MONTGJE SMITHED NST 12345  
 Desc: NST TEST 
251  8681 8681  8681 A MONTGJE SMITHED NST 56789  
 Desc: NST W/ PHI 
252  8681 8681  8681 A MONTGJE SMITHED NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
253  8681 8681  8681 S MONTGJE PURCHASING NST 12345  
 Desc: NST TEST 
254  8681 8681  8681 S MONTGJE PURCHASING NST 56789  
 Desc: NST W/ PHI 
255  8681 8681  8681 S MONTGJE PURCHASING NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
256  8681 8681  6700 A MONTGJE SAVOYM NST 12345  
 Desc: NST TEST 
257  8681 8681  8681 A MONTGJE SAVOYM NST 56789  
 Desc: NST W/ PHI 
258  8681 8681  8681 A MONTGJE SAVOYM NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
259  8681 8681  8681 A MONTGJE SMITHED NST 12345  
 Desc: NST TEST 
260  8681 8681  8681 S MONTGJE PURCHASING NST 56789  
 Desc: NST W/ PHI 
261  8681 8681  8681 A MONTGJE SMITHED NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
262  8681 8681  8681 A MONTGJE MONTGJE NST 12345  
 Desc: NST TEST 
263  8681 8681  8681 A MONTGJE MONTGJE NST 56789  
 Desc: NST W/ PHI 
264  8681 8681  8681 A MONTGJE MONTGJE NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
265  8681 8681  8681 A MONTGJE MONTGJE NST 12345  
 Desc: NST TEST 
266  8681 8681  8681 A MONTGJE MONTGJE NST 56789  
 Desc: NST W/ PHI 
267  8681 8681  8681 A MONTGJE MONTGJE NST 9876  
 Desc: NST WITH REPEATING CONTRACT 
40000636  8681 8681  8681 A CDPPJMP SMITHED NST A000000000000001  
 Desc: AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 
40000637  8681 8681  8681 A CDPPJMP CDPPKWM NST B000000000000001  
 Desc: AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 



 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Pilato
Sent: Friday, February 15, 2008 9:31 AM
To: displaytag-user@lists.sourceforge.net
Subject: Re: [displaytag-user] [displaytag - Open Discussion] PleaseHELP 
-question on SORTING

Hi,


Perhaps you should use defaultsort="1" and defaultorder="ascending"

Something like :
<display:table sort="list" name="actionBean.results"
decorator="org.texashealth.scm.displaytag.decorator.SCMTableDecorator"
pagesize="50" requestURI="/reqs/Search.action" class="reqList"
defaultsort="1" and defaultorder="ascending">


David.

> -----Original Message-----
> From: [EMAIL PROTECTED] 
> [mailto:displaytag- [EMAIL PROTECTED] On Behalf Of 
> SourceForge.net
> Sent: vendredi 15 février 2008 16:27
> To: [EMAIL PROTECTED]
> Subject: [displaytag-user] [displaytag - Open Discussion] Please HELP 
> - question on SORTING
> 
> 
> Read and respond to this message at:
> https://sourceforge.net/forum/message.php?msg_id=4779994
> By: savoym
> 
> My SQL query sorts by the REQNNUM value in a ASC order by default.  
> The information in my DISPLAYTAG table is sorted correctly when I 
> first come into my JSP page.
> The problem is that when I click on the REQ # title in the first 
> column of my table the order should change to a DESC order however the 
> order is anything but.  There appears to be no order in which the rows 
> are displayed and they are NOT displayed by REQ # order at all.
> 
> I've read through the website and I've tried entering an EXTERNAL sort 
> in the table tag in my JSP page with a sortNAME of the column name but 
> to no avail.
> I'm just not sure how to proceed.  I am NOT using the EXTERNAL 
> PAGING/SORTING option and do not know why I would have to.
> 
> Any help or direction would be greatly appreciated.  The code for the 
> JSP page, table decorator that I created, and the SORT property 
> setting in my DISPLAYTAG properties file is all below:
> 
> I have the following in my JSP page:
> 
> <display:table sort="list" name="actionBean.results"
> decorator="org.texashealth.scm.displaytag.decorator.SCMTableDecorator"
> pagesize="50"
> requestURI="/reqs/Search.action" class="reqList">
>     <display:column property="reqNumLink" title="Req #" sortName="REQNUM"
> sortable="true" class="reqNum"/>
>     <display:column property="poNum" title="PO #" class="poNum"/>
>     <display:column property="delivrToDeptCode" title="Del" class="del"/>
>     <display:column property="chrgToDeptCode" title="Chg" class="chg"/>
>     <display:column property="srceLocation" title="Src" class="src"/>
>     <display:column property="purchDeptCode" title="Pur" class="pur"/>
>     <display:column property="recStatus" title="St" class="st"/>
>     <display:column property="createdBy" title="Created By"
> class="created"/>
>     <display:column property="assignedTo" title="Assign To"
> class="assigned"/>
>     <display:column property="reqTypeValue" title="Typ" class="typ"/>
>     <display:column property="vendorCatNum" title="Vendor Cat #"
> class="vnd"/>
>     <display:column property="itemNum" title="Item #" class="item"/> 
> </display:table>
> 
> In my DISLAYPROPERTIES file:
> 
> # page | list
> sort.amount=list
> 
> In my DECORATOR:
> 
> public String getReqNumLink() {
>       final SearchResults reqValues = (SearchResults) 
> getCurrentRowObject();
>       final String reqNum = reqValues.getReqNum().trim();
>       final String entity = reqValues.getEntityCode().trim();
> 
>       if (reqValues.isNonStock())
>               return "<a href = \"/reqs/NonStock.action?view=&reqNum=" + 
> reqNum
> + "&entityCode=" + entity + "\">" + reqNum + "</a>";
>       else if (reqValues.isNonStockCredit())
>               return "<a href =
\"/reqs/NonStock.action?viewCredit=&reqNum="
> + reqNum
> + "&entityCode=" + entity + "\">" + reqNum + "</a>";
>       else if (reqValues.isStock())
>               return "<a href =
> \"/reqs/StockRequisition.action?view=&reqNum=" + reqNum
> + "&entityCode=" + entity + "\">" + reqNum + "</a>";
>       else if (reqValues.isStockless())
>               return "<a href =
> \"/po/StocklessRequisition.action?view=&reqNum=" + reqNum
> + "&entityCode=" + entity + "\">" + reqNum + "</a>";
>       else if (reqValues.isStocklessCredit())
>               return "<a href
> = \"/po/StocklessRequisition.action?viewStocklessCreditReq=&reqNum=" + 
> reqNum
> + "&entityCode=" + entity + "\">" + reqNum + "</a>";
>       else if (reqValues.isInventory())
>               return "<a href =
> \"/po/InventoryRequisition.action?view=&reqNum=" + reqNum
> + "&entityCode=" + entity + "\">" + reqNum + "</a>";
>       else if (reqValues.isInventoryCredit())
>               return "<a href =
> \"/po/InventoryRequisition.action?viewInvCreditReq=&reqNum="
> + reqNum + "&entityCode=" + entity + "\">" + reqNum + "</a>";
>       else if (reqValues.isCapital())
>               return "<a href = \"/reqs/NonStock.action?view=&reqNum=" + 
> reqNum
> + "&entityCode=" + entity + "\">" + reqNum + "</a>";
>       else if (reqValues.isCapitalCredit())
>               return "<a href =
\"/reqs/NonStock.action?viewCredit=&reqNum="
> + reqNum
> + "&entityCode=" + entity + "\">" + reqNum + "</a>";
> 
>       return reqNum;
>     }
> 
>     public String getReqTypeValue() {
>       final SearchResults reqValues = (SearchResults) 
> getCurrentRowObject();
> 
>       if (reqValues.isNonStock())
>                       return "NST";
>               else if (reqValues.isNonStockCredit())
>               return "CRN";
>       else if (reqValues.isStock())
>               return "STK";
>               else if (reqValues.isCapital())
>               return "CAP";
>               else if (reqValues.isCapitalCredit())
>               return "CRP";
>               else if (reqValues.isStockless())
>               return "STL";
>       else if (reqValues.isStocklessCredit())
>               return "CRL";
>       else if (reqValues.isInventory())
>               return "INV";
> 
>       // Req should be an Inventory Credit
>               return "CRS";
>     }
> 
> 
> ______________________________________________________________________
> You are receiving this email because you elected to monitor this forum.
> To stop monitoring this forum, login to SourceForge.net and visit:
> https://sourceforge.net/forum/unmonitor.php?forum_id=249317
> 
> ----------------------------------------------------------------------
> --- This SF.net email is sponsored by: Microsoft Defy all challenges. 
> Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> displaytag-user mailing list
> displaytag-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/displaytag-user


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) 
Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
displaytag-user mailing list
displaytag-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-user




The information contained in this message and any attachments is intended only 
for the use of the individual or entity to which it is addressed, and may 
contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from 
disclosure under applicable law.  If you are not the intended recipient, you 
are prohibited from copying, distributing, or using the information.  Please 
contact the sender immediately by return e-mail and delete the original message 
from your system.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
displaytag-user mailing list
displaytag-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-user

Reply via email to