Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[sbdallas]

I'm trying to make a smartlist that plays a list of videos.  I want the videos ordered by Last Played such that the oldest Last Played date is first, but I want videos that have a value of 'never played' to come first in order.

I have tried sorting by Last Played both A-Z and Z-A, but I always get the videos with date values first and videos with 'never played' last.  Is there a way to force the 'never played' videos to the top of the list?

Thanks,
Scott

[gappie]

there is a setting in options>tree and view>sorting... sort empty strings last.. disable that. does that help.

 
gab

[sbdallas]

That does indeed work.  Thanks

However, I would rather not use a global setting to accomplish this if I don't have to.  Is there any way to achieve this within the confines of the smartlist settings?

[wig]

That does indeed work.  Thanks

However, I would rather not use a global setting to accomplish this if I don't have to.  Is there any way to achieve this within the confines of the smartlist settings?

Sure. Create a custom library field. Call it 'My Last Played', for example.

Choose calculated Data Field. Paste this expression in there

if(isequal([Last Played],Never Played,1),0,ConvertDate([Last Played]))

Now sort on My Last Played.

[sbdallas]

Perfect.  Thanks!