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
