INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Sorting issues with new date system  (Read 1176 times)

Marty3d

  • Citizen of the Universe
  • *****
  • Posts: 1363
Sorting issues with new date system
« 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
Logged


Marty3d

  • Citizen of the Universe
  • *****
  • Posts: 1363
Re: Sorting issues with new date system
« Reply #1 on: February 20, 2006, 03:28:55 pm »

Another bump :)
Logged


Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42323
  • Shoes gone again!
Re: Sorting issues with new date system
« Reply #2 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.
Logged
Matt Ashland, JRiver Media Center

Marty3d

  • Citizen of the Universe
  • *****
  • Posts: 1363
Re: Sorting issues with new date system
« Reply #3 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
Logged


Pages: [1]   Go Up