INTERACT FORUM

Please login or register.

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

Author Topic: Smartlist - sort by [Number Played] doesn't include nulls  (Read 1814 times)

kkrug

  • Member
  • *
  • Posts: 2
Smartlist - sort by [Number Played] doesn't include nulls
« on: March 29, 2009, 04:34:59 pm »

I'm using MC12
I'd like a smart list that plays my least recently played tracks including tracks I haven't played yet. I tried adding the modifier ~sort=[Number Plays],  but this exlcudes all tracks that have yet to be played. I assume this is because the column contains nulls and nulls must sort last for some reason. 

I see I can use the "-d" switch to sort in descending order, but haven't found anywhere where I can make Nulls sort first.

I've tried playing with functions, but can't get the hang of it. I tried using PadNumber([Number Plays],1) , but that gets converted to:
Media Type]=[Audio] ([Number Plays]) ~sort=padnumber

I also tried to create an Expression Column (a custom column I called Nbr Plays) that was also defined as PadNumber([Number Plays],1). This did give me a new column that contains zeros for rows that haven't played yet, but it seems I cant use this custom column as a sort modifier - bummer!  :'(


Anybody have an idea how I can get my unplayed music to sort to the top?
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 8939
Re: Smartlist - sort by [Number Played] doesn't include nulls
« Reply #1 on: March 29, 2009, 04:50:49 pm »

Tools > Options > Tree and View > Sorting.... uncheck "sort empty strings last"

:)

kkrug

  • Member
  • *
  • Posts: 2
Re: Smartlist - sort by [Number Played] doesn't include nulls
« Reply #2 on: March 29, 2009, 05:04:37 pm »

I was hoping it would be something simple like that  ::)
Thanks for the quick reply!!!
Logged
Pages: [1]   Go Up