1
3rd Party Plugins - (fb2k) / Re: [fb2k v2] SQL Tree (foo_uie_sql_tree)
Last post by dix-hill -Code: [Select]
GroupingCould I assign Album, Compilation, and EP to their own playlists? I know I can assign 1 playlist for the query with Activate / Target Playlist.
---Album >>> Album Playlist
---Compilation >>> Compilation Playlist
---EP >>> EP Playlist
I also found these in the forum/help files and they worked as is, but I couldn't get them to work with an alias from a created table:
Code: [Select]
INSERT INTO PlaylistUpdatable(path,subsong)
SELECT path,subsong
FROM MediaLibrary
WHERE artist='Metallica';
Code: [Select]
INSERT INTO PlaylistUpdatable(path,playlist_name)
SELECT a.path,b.playlist_name
FROM MediaLibrary a,
(SELECT 'Metallica' "playlist_name"
UNION ALL
SELECT 'Heavy Metal') b
WHERE artist='Metallica';