1
3rd Party Plugins - (fb2k) / Re: [fb2k v2] SQL Tree (foo_uie_sql_tree)
Last post by fbuser -There is no mention of it in the docs so I assume it's not currently possible, but it would be neat if one could use SQL query syntax to generate titles for target playlists.Although not explicetly, it acutally is:
Quote
Inserting entries into the Playlist table will result in adding items to the relevant playlists.
...
If the specified playlist doesn't exist, it will be created.
The only limitiation is that you also need to add tracks to the new playlist. This
Code: [Select]
INSERT INTO PlaylistUpdatable(path,playlist_name)will create the playlist "New Playlist" with one empty, invalid track. For sure it would be better to populate this playlist with existing tracks, e.g.
SELECT '','New Playlist';
Code: [Select]
INSERT INTO PlaylistUpdatable(path,subsong,playlist_name)assuming that there are tracks from Motörhead in your library.
SELECT path,subsong,'Motörhead'
FROM MediaLibrary
WHERE artist='Motörhead'