INTERACT FORUM

Please login or register.

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

Author Topic: Auto playlist sorts descending order wrongly  (Read 1400 times)

amiti

  • Recent member
  • *
  • Posts: 24
Auto playlist sorts descending order wrongly
« on: October 03, 2013, 07:45:50 am »

Hello , I am using MC 18.201

I created a math expression field in the library by calculating [number of plays]* [rating] / [age] . I took into account the formatnumber() problem and succeeded eventually to get the wanted results. The problem though is in the auto playlist creator. When sorting that field in ascending order all is going well but sorting in descending order give weird results. I tried turning the number to integer by multiplying it or padding it with zeros but nothing seem to help.

Is it a bug or am I doing something wrong?

Thank you.
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Auto playlist sorts descending order wrongly
« Reply #1 on: October 03, 2013, 11:47:50 am »

Some comments:

I've reported several sorting issues, but don't know if this case is the same

Is the expression field an Integer or Decimal field, or did you cast the expression to either of these?

Can you share the screenshots so we can see what is happening.  Minimize the number of entries just enough to show the problem.
Logged
The opinions I express represent my own folly.

amiti

  • Recent member
  • *
  • Posts: 24
Re: Auto playlist sorts descending order wrongly
« Reply #2 on: October 07, 2013, 02:50:11 pm »

Thank you for your help.

I added data type and formatnumber() to whereever might be a problem. It seems to work now correctly.

Maybe the problem lies with the calculations delay which cause weird results in smart playlists if you change expression fields too quickly?
Logged
Pages: [1]   Go Up