This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JForum and the fly likes Member Listing Sort Order - Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Member Listing Sort Order - "odd"" Watch "Member Listing Sort Order - "odd"" New topic
Author

Member Listing Sort Order - "odd"

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I found it in an oracle-specific query in oracle.sql.

I changed it to order by user_id descending, so the latest entry would be on top.

I could, alternatively have sorted it by upper(username), or whatever else i WANTED. I tried several variations, and like seeing the latest registered users first, in reverse order of registration.

Thanks,
Jennifer
[originally posted on jforum.net by jenamon]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
When I look at my member listing, it's oddly sorted. It appears to be sorted generally in order of registration, or user #, but not really. The first 29 users are on page 1, but they are sorted on that page in case-sensitive alpha order by username. Then, the next 30 users (why 29 on page 1) are displayed on page, 2, again sorted in case-sensitive alpha order. That results in an order that looks like this:

Page 1 (users 1-29):
Axxx
Bxxx
Cxxx
...
Zxxx
axxx
bxxx
cxxx
...
zxxx

Page 2 (users 30-59):
Axxx
Bxxx
Cxxx
...
Zxxx
axxx
bxxx
cxxx
...
zxxx

Can someone please point me to the code that might be doing this. I'd prefer either a straight case-INsensitive sort across all pages, or a sort by user number or reverse user number, across all pages. The alpha sub-sort on each page is enough to drive one to drink.

This is v2.1.7, with Oracle and tomcat.

Thanks,
Jennifer
[originally posted on jforum.net by jenamon]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
The sql statement itself can be found in the engine dependand sql files for selections ...

But: as far as I know it's the collation being used that is responsible for ordering - hence take a look at the collation setting in the conf / db server conf ... and reconfigure your db server possibly... to use the collation that will sort the way you like ... ^^
[originally posted on jforum.net by Sid]
 
Consider Paul's rocket mass heater.
 
subject: Member Listing Sort Order - "odd"