Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Multiple Column Sorting
14/12/2009
15:09
Avatar
TriLLi
New Member
Members
Forum Posts: 1
Member Since:
14/12/2009
sp_UserOfflineSmall Offline

Hi I am interested in Multiple column sorting (e.g. Sort By Name and Age), so Peoples with same name will be ordered by Age...

Do you have this in plan and if you do when ?

Thanks in advance.

15/12/2009
18:27
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

Hello,

There is no plan for this feature, but we consider a possibilty to define custom sort function where you can do define this behaviour.

Best Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

14/04/2010
01:52
Avatar
ddotsenko
Member
Members
Forum Posts: 15
Member Since:
08/03/2010
sp_UserOfflineSmall Offline

I was thinking about implementing the feature. 

There are two major items to be addressed here:

1. The way sorting rules are integrated into postdata only allows one set of sorting rules to be communicated to the server.

Perhaps the most sensible approach to this is copy how filter rules for multipleSearch are merged into postdata:

 postdata = {

...

sortingrules = [{rule1},{rule2},{rule3}]

...

}

2. The method for choosing the sorting column order could be very simple:

 - MultiSelect plug in allows to "include / exclude / order" items from a list. Set up a button on the toolbar that calls The behavior could be very similar to how this MultiSelect widget is called now for column ordering / hiding.

I completely bypassed the need for multiple sort order rules, however, by keeping the last order of data in data source. Every time I click on "sort column" it sorts against the order from the last sort and keeps subgroup order from prior sorts intact.

16/04/2010
01:34
Avatar
jacobmarble
Logan, UT, USA
Member
Members
Forum Posts: 4
Member Since:
16/04/2010
sp_UserOfflineSmall Offline

I really need this feature.  From the user perspective, it's annoying when you sort by column A, then by column B, and column A isn't sorted any more.  What ddotsenko said makes sense.  I like to think of simulating a stable sorting algorithm.  Most users anticipate a stable sort when they sort column A, then column B.

This seems like an obviously important feature to me.

16/04/2010
16:52
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

Hello,

I do not promiese, but will make a initial work.

Another thing that we must do is manipulating the sortings icons on the grid correct.

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

17/04/2010
01:24
Avatar
jacobmarble
Logan, UT, USA
Member
Members
Forum Posts: 4
Member Since:
16/04/2010
sp_UserOfflineSmall Offline

tony said:

Hello,

I do not promiese, but will make a initial work.

Another thing that we must do is manipulating the sortings icons on the grid correct.

Regards

Tony


The sorting icons shouldn't change if you implement a stable sort.  This link describes what the user might see if the jqGrid "multi-column sort" were enabled:

http://en.wikipedia.org/wiki/H.....ondary_key

Of course, with a database backend you can't really sort stably, but we could call it a "virtual" stable sort, keeping track of the order and asc/desc of each column in the sort.

21/04/2010
20:39
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

Hello,

Thanks for the link.

Best Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

29/09/2010
23:32
Avatar
BerndNaverisk
New Member
Members
Forum Posts: 1
Member Since:
29/09/2010
sp_UserOfflineSmall Offline

Hi

This is a really basic and crucial feature which will render every grid useless in modern applications if its missing.

Is there a way now (3.8), to have multiple column sorting? Even a workaround will be ok, I am providing the data from a call to my WebService which takes care of sorting paging and filtering, but I need the parameters from the grid.

Cheers

Bernd

19/03/2012
02:28
Avatar
Rat
Member
Members
Forum Posts: 8
Member Since:
09/03/2012
sp_UserOfflineSmall Offline

...see my working mutli-column sorting(ordering) code here.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
30 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information