Hello.
I'm trying to make a node to rertrieve only music located in my main library folder, and excluding other folders containing recently ripped or downloaded music. I'm using WHERE to achieve this. However the node doesn't list any album at all.
This is the batch part of the node.
DROP VIEW IF EXISTS album_query;
CREATE VIEW album_query AS
SELECT path,
upper(substr(tf(metadb_handle,'$stripprefix(%album artist%)'),1,1)) first_letter,
ifnull([album artist],artist) album_artist,
'['||date||'] '||album album_col,
(CASE WHEN discnumber THEN 'Disc '||discnumber ELSE NULL END) disc_number,
MetaDb_Handle
FROM MediaLibrary
WHERE path LIKE 'e:\music%'
GROUP BY 1,album,discnumber
ORDER BY album_artist, album_col, disc_number, tracknumber
And the query
SELECT first_letter,
album_artist,
album_col
FROM album_query
I took most of the lines from the examples, only adding the WHERE clause after reading some SQLite documentation.