INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: Marty3d on February 11, 2006, 12:23:24 pm

Title: Sorting issues with new date system
Post by: Marty3d on February 11, 2006, 12:23:24 pm

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

Title: Re: Sorting issues with new date system
Post by: Marty3d on February 20, 2006, 03:28:55 pm

Another bump :)

Title: Re: Sorting issues with new date system
Post by: Matt on February 20, 2006, 04:43:32 pm

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.

Title: Re: Sorting issues with new date system
Post by: Marty3d on February 20, 2006, 04:51:58 pm

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