• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Multi Level Sorting

 
Soumya Saha
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Anybody has any idea about how to do multi level sorting on a table.Any help will be highly apreciated

Thanks
 
Eric Pascarello
author
Rancher
Posts: 15385
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
JavaScritp can not handle large tables to be sorted, You can only do it on a small level before the browser freezes.

Eric
 
Soumya Saha
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Eric,
Thanks for the reply.Any Idea on how I can resolve this issue where I have 50 rows and I have to sort it in multiple levels.I can do a single level sorting.Any replies will be highly appreciated

Thanks
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64620
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Databases are really good at sorting.
 
Soumya Saha
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Bear,
Thanks For the reply.I am already doing it from database only.But the prob is that I have next/prev buttons and the back/forth logic is based on the primary key.So the sort order selection is mixing it all.that's why I want to go for html.

thanks
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64620
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I still don't see why you don't let the db do the sorting. I do it all the time.
 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, database sorting is a good way to go. I did this at my last job and created similar code at my new job. The paging is all done on the client side, but the column sort is done on the server side via an Ajax call. Works like a champ.

But the prob is that I have next/prev buttons and the back/forth logic is based on the primary key.So the sort order selection is mixing it all.

You just need to keep track of that data better is all.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic