Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Marty3d]

Hi!

I accidentally stumbled across this one.

If you create an expression like FormatDate([Last Played,0],elapsed), then the sort order is out of order. I don't mean in the setup of the view, but when you click on the column.

My list will be sorted like this:
1,06 years
1,22 years
01:04:41
02:02:39
2,3 days
2,04 years
02:08:16
24,6 hours
etc...

Is it possible to fix this, JRiver? Or are there workarounds?

Thanks,
/Martin

[Marty3d]

Another bump

[Matt]

Expression-type columns are sorted using a combination number/string sorter.  Some more complicated types like months or durations are supported in &Sort=[...] fields.

There's no way to specify a different sort expression than display expression at this point. (which is what would be needed for the example you posted)

Thanks.

[Marty3d]

Thanks for your quick reply Matt!

Just a thought; Could one not implement/change sorting for dates using the internal date format?
If I got it right, the internal figure for a date is a long line of numbers, like '12345678' or something.
If for example
'2005-10-01 22:00' translates to '123456789' and
'2005-11-01 22:00' translates to '234567890' and
'2005-09-01 22:00' translates to '012345678'

then you have a quite easy sorting order, right? The higher dates and times the greater number. That, of course, is only correct if that's the case

Anyway, since it's not a critical thing, I leave you to do your work, but it's something to consider, isn't it?

Thanks!
/Martin