I want to be able to set up an dynamic playlist to play random not rated tracks
in a selected year.
I can almost do this via browsing to a year, and invoking the TrackStat mixer
and selecting "not rated songs". However, this is not a dynamic playlist, it
generates an ordered playlist of 50 songs.
So I set about making a SQL Playlist with parameters to do exactly what I
wanted.
I then found a template that was close to what I wanted: Random for
rating/year. This asks for rating, and then lists years that contain songs
with that rating. I have changed that one so that it asks for a year first,
and then a list of ratings, and it seems to work as a year mixer (I thought I
may need to do that for it to work from the starting context of a year). The
only problem is it doesn't allow for not rated tracks as a choice.
So I created my own SQL Playlist "random not rated tracks in year" that only
asks for a year, and only finds songs with no trackstat rating:
-- PlaylistName:Random not rated songs for year
-- PlaylistGroups:Random,Songs
-- PlaylistParameter1:year:Select year:
select tracks.url from tracks
left join track_statistics on
tracks.url=track_statistics.url
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
audio=1
and tracks.year='PlaylistParameter1'
and dynamicplaylist_history.id is null
and track_statistics.rating is null
group by tracks.id
order by rand()
limit 10;
That SQL Playlist seems to be working correctly, and I've chosen it as a
Favorite Dynamic Playlist, but I don't get it in my list of Dynamic Playlist
mixers when I start from a year.
Is there any other magic I need to do to get it to work from a year mixer?
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins
