Page 1 of 1
Identifying tracks not in a playlist
Posted: Sun Aug 26, 2007 9:03 pm
by aireq
Is there a way to identify which tracks are currently not in a playlist? I DJ CDs and either record my tracks to my computer, or purchase songs online. I want to track which tracks I've recorded to a CD. So I'm going to make a play list for each CD I create. But I want to be able to see what tracks I haven't put on a playlist and thus CD yet.
I've tried to figure out how I could get magic nodes to do this but I can't figure it out. Any one have any ideas?
Eric
Posted: Sun Aug 26, 2007 9:07 pm
by nynaevelan
Hi Eric:
Here is the code I use to create a Magic Node of those songs which are not in a playlist:
Songs Not In Any Playlist|SQL filter: not exists (select * from PlaylistSongs where IDSong=songs.ID)\<genre>\<artist>
Nyn
Posted: Sun Aug 26, 2007 9:12 pm
by Bex
Posted: Mon Aug 27, 2007 1:48 am
by nynaevelan
Sorry Bex, I hope my reply did not imply that I was the creator of the code for the node. Next time I will point the answer to the place where I found a solution.
Nyn
Posted: Mon Aug 27, 2007 2:08 am
by Bex
No problem at all nynaevelan! In fact, i didn't even see your post when I posted mine.
(I'm a slow poster sometimes.)
Posted: Mon Aug 27, 2007 3:04 am
by aireq
Thanks, this works great.
Re: Identifying tracks not in a playlist
Posted: Fri Aug 29, 2008 12:36 pm
by netmatt
This code isn't working in the latest release, or maybe just on my machine? I get a - Error executing SQL....:no such column: Songs.IdArtist (1,1)
The whole SQL script is in the ... area
Re: Identifying tracks not in a playlist
Posted: Fri Aug 29, 2008 1:09 pm
by netmatt
netmatt wrote:This code isn't working in the latest release, or maybe just on my machine? I get a - Error executing SQL....:no such column: Songs.IdArtist (1,1)
The whole SQL script is in the ... area
Sorry, still works, ends up 1.3b of Magic Nodes, which comes with MM 3, does not work with MM3 !?!
Got a Beta of 1.7.7, and it works fine now...
