Grid sorting on TWO FIELDS. anyone figured this out?

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
Jaymer
Posts: 2501
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Grid sorting on TWO FIELDS. anyone figured this out?

Post by Jaymer »

Has anyone played around with creating a primary and then a secondary sort inside a grid (by the end user clicking on headings)?
I’m sure it would require tinkering with the Kendo JavaScript.
… And I mean without using grouping.

The grouping certainly helps, but if a user wanted to click on the first sort field, and then, click on a second field to sort inside that, that’s more what I’m looking for.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Posts: 2501
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Grid sorting on TWO FIELDS. anyone figured this out?

Post by Jaymer »

bump
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
himanshu
Posts: 728
Joined: Thu Jun 19, 2008 6:24 am
Location: India
Contact:

Re: Grid sorting on TWO FIELDS. anyone figured this out?

Post by himanshu »

try this on your grid init script

config.sortable = {mode: 'multiple'};
From,
Himanshu Jain


AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
Jaymer
Posts: 2501
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Grid sorting on TWO FIELDS. anyone figured this out?

Post by Jaymer »

himanshu wrote: Thu Jul 11, 2024 3:02 am config.sortable = {mode: 'multiple'};
thx H

it activates that kendo ability, but clicking on the 2nd columns doesn't alter the display of any rows.
the 2nd 'arrow' appears on the 2nd column, and a redraw happens, but no sort order changes.

have you actually seen this work?
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
himanshu
Posts: 728
Joined: Thu Jun 19, 2008 6:24 am
Location: India
Contact:

Re: Grid sorting on TWO FIELDS. anyone figured this out?

Post by himanshu »

No Jaymer I actually not used before. I try to test the same and you are right it's not doing what it suppose too.

Will update if found it working, if get time further to investigate.
From,
Himanshu Jain


AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
hpl123
Posts: 2622
Joined: Fri Feb 01, 2013 1:13 pm
Location: Scandinavia

Re: Grid sorting on TWO FIELDS. anyone figured this out?

Post by hpl123 »

Not sure why this doesn´t work and if it should work but one thing I know is that Aware (KendoUI) also has something called server sorting (Kendo has both client i.e sorting directly in the grid and server sorting i.e sorting applied before the data is displayed) and could possibly be the cause of this i.e you also have to do something with the server sorting. Just a wild shot guess though and I don´t know how the sorting and these things work fully so take with a grain of salt.

You could also experiment a bit e.g with the following scripts:
https://www.awareim.com/forum/viewtopic ... 026#p58026
Henrik (V8 Developer Ed. - Windows)
aware_support
Posts: 7540
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Grid sorting on TWO FIELDS. anyone figured this out?

Post by aware_support »

Henrik is right - this has to be supported on the server and at the moment it is not. Unless, of course, you define a few Aware IM queries with multiple sorting and you switch between those.
Aware IM Support Team
Post Reply