FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Feature Requests › "top … order by" Syntax for smart playlists › Reply To: "top … order by" Syntax for smart playlists
13/07/2007 at 11:18 AM
#10932
mpoly
Participant
There are lots of requests on playlists, many of which are quite hard to implement because they require Ron to expand and parse more complicated expressions.
Here’s an idea: Allow smart playlist expressions in the format:
SQL:
Where sqlstatement is any SQL that returns a list of Ids from the database. This could be an expert-only feature, with disclaimers:
- This is not officially supported
There is no syntax checking
Portability and compatibility with future versions is not guaranteed
If you accidentally type in DROP TABLE, its your problem.
For those who know basic SQL (and those who know how to ask questions nicely in the forums), this will open many new possibilities.
?