More > Media Center 12 (Development Ended)

Smartlist - sort by [Number Played] doesn't include nulls

(1/1)

kkrug:
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?

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

:)

kkrug:
I was hoping it would be something simple like that  ::)
Thanks for the quick reply!!!

Navigation

[0] Message Index