FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Feature Requests › Limit Smart Playlist Length
- This topic has 4 replies, 2 voices, and was last updated 17 years, 2 months ago by
rpedde.
-
AuthorPosts
-
07/03/2006 at 12:49 AM #194
Anonymous
InactiveI think it would be really cool if playlists could be limited in length. For example:
genre includes “rock” limit length 5 songs
genre includes “rock” limit length 20 minutes
I guess that this could be simplified to only use a number of songs with something like:
genre includes “rock” AND song_length >= 180 AND song_length
Post edited by: ajayre, at: 2006/03/06 16:53
07/03/2006 at 12:55 AM #4070Anonymous
Inactive.
Post edited by: ajayre, at: 2006/03/06 16:56
07/03/2006 at 12:55 AM #4071Anonymous
InactiveContinued:
genre includes “rock” AND song_length >= 180 AND song_length < = 240 limit 5 songs
would produce a playlist 15 – 20 minutes long.
Looking back through the forum, it appears that an SQL syntax was supported for smart playlists. Is this still supported? I know it could do what I want as well as other things like ordering a playlist, which I also would like to do.
Andy
Post edited by: ajayre, at: 2006/03/06 16:58
07/03/2006 at 12:56 AM #4072Anonymous
InactivePosting a < symbol chops the rest of your post off from that point onwards.
Andy
Post edited by: ajayre, at: 2006/03/06 16:57
07/03/2006 at 7:23 AM #4073rpedde
ParticipantYeah, it *used* to be raw sql, but moved away, as it made it impossible to have a non-sql backend, or a backend that used a different dialect. For example, almost every db has different limit statements, so something that worked on sqlite wouldn’t work on mysql, which wouldn’t work on postgres, which *certainly* wouldn’t work on gdbm. And so forth.
Also, I eventually hope to be able to use playlists as a base library — for example, have a smart playlist like:
kids songs: comment !includes “explicit”
and then have a username and password (kids/kids), that uses that playlist as the “base” playlist. Then every other playlist would be a subselect on that one. It would be reasonably easy to do if the playlist was a simple where clause without sort info.
If that makes sense.
-
AuthorPosts
- The forum ‘Feature Requests’ is closed to new topics and replies.