Using a renderer on a column doesn't seem to work with sort?

[donalconlon]

I have a col with the value: float;#300.000000000000
I am using a renderer to return: '300'

After I do that, the column sort has no effect on the grid. So I guess my questiosn is does the sortType only refer to the dataModel, and not the rendered data?

I am using the following

{header: "Avg Hours", width: 120, sortable: true, sortType: sort.asInt, renderer: this.renderTypeFloat},

[tryanDLS]

Yes, but you could define a new sortType (other than asInt), which applies your renderer to the data.

[jack.slocum]

I'm confused as to whats going on? Can you explain further?

[tryanDLS]

His data value looks like it's actually on object containing type and value. The renderer returns the value, but sort is probably treating the entire thing as a string so, it probably doesn't make sense if you sort 'float, 300' and 'int,200'.

[donalconlon]

Hi Jack.

What I have is funky xml that i'm loading into the dataModel. One of the column values is represented as:
"float;#300.000000000000"


I am using a renderer function to convert this to "300" as an int:

{header: "Approved Hours", width: 120, sortable: true,sortType: sort.asInt, renderer: this.renderTypeVariant}

renderTypeVariant : function(val){
		if(val != '')
			return(parseInt(val.substring(val.indexOf('#')+1)));
	},

After doing the render, clicking the column header to sort as an integer does not do any sort at all.

[jack.slocum]

What you are looking for is preprocessor to reformat funky xml into a valid number. Something like:

// add preprocessor to the second data column
dataModel.addPreprocessor(2, function(value){
    if(value != ''){
          value = parseInt(value.substring(value.indexOf('#')+1), 10);
    }
    return value;
});

The difference is this parses the data as it is coming in and then sort and renderers will both use the parsed value (rather than parsing and/or converting on every sort and/or render).

[donalconlon]

That did the trick!! Thanks Jack. So on that note, when would you use a renderer instead of a pre-processor?

[jack.slocum]

I would use a renderer when the data is in the correct format, but you want it rendered differently. For example, your data has the values 1, .5, 2.3, 4.5 and you want them rendered $1.00, $0.50, $2.30 etc. Or another example would be your data contains Date objects and you want them rendered as formatted strings.