Column sorting question

Ok, customers want the world - lol.
Here's what I got to figure out.

DataSet has these columns:

QueueID, Location, Type, Description, Date1, Date2
b0001, Delaware, Breaker, Circuit Replacement, 12/12/2007, 12/13/2007

On the grid, we have a column called "Description" that is a compound of Location, Type, Description

It makes the row look something like:
QueueID Date1 Description
b0001 12/12/2007 Location: Delaware
Type: Breaker
Desc: Circuit replacement

Note, in the above, we are not dispalying the Location column, we are building a compound description because of spacing on the page the grid is on.

Now, the powers-that-be, want it to SORT the description column on the Type value.

Is there a way to tell as specific column header to sort based on a different column? So, I'd want the Description column (3) to actually sort the grid on column (2) that isn't displayed.

June 13,
The sorting is based on cellValue property which might be different from cellText. For example, you can assign a function to cellValue which returns the value from another column -

var value1 = function(c, r){
    return this.getCellValue(1, r); // get value from column-1

obj.setCellValue(value1, 0); // assign to column-0
Alex (ActiveWidgets)
June 13,
ok .. I'll try it and let you know what happens.

June 13,

This topic is archived.

See also:

Back to support forum