Sort on one value but display another

mcraig

Don't know how to better explain this. I'm doing a demonstration of the grid to a client for my boss and he explains: If this field has no date, display "Not Installed"...in and of itself, no big deal...but because the column otherwise contains date values, when initially sorted all the "Not Installed" values appear at the top of the table and the client is going to want those last. So I though, ok, I'll bury a date value of 1/1/1900, an impossible value for all the other dates that would appear in the data...but then I can't display "Not Installed" AND sort by date.

I had the thought that I could create a dummy field with the dates and a display field column, but how do I get a click on the sort header for what the user sees to actually sort on what the user doesn't?

Or maybe that is not the right approach?

Help? I really want to pull this demo off.

dmclean

Use a custom sorter.

If one value is "Not Installed" then it is greater than any other value (putting it at the end). Otherwise do a regular date comparison.