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
Identifying tracks not in a playlist
Moderator: Gurus
-
nynaevelan
- Posts: 5559
- Joined: Wed Feb 07, 2007 11:07 pm
- Location: New Jersey, USA
- Contact:
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
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
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins
Join Dropbox, the online site to share your files
Link to Favorite Scripts/Skins
Join Dropbox, the online site to share your files
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
-
nynaevelan
- Posts: 5559
- Joined: Wed Feb 07, 2007 11:07 pm
- Location: New Jersey, USA
- Contact:
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
Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins
Join Dropbox, the online site to share your files
Link to Favorite Scripts/Skins
Join Dropbox, the online site to share your files
No problem at all nynaevelan! In fact, i didn't even see your post when I posted mine. 
(I'm a slow poster sometimes.)
(I'm a slow poster sometimes.)
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
-
netmatt
Re: Identifying tracks not in a playlist
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
The whole SQL script is in the ... area
-
netmatt
Re: Identifying tracks not in a playlist
Sorry, still works, ends up 1.3b of Magic Nodes, which comes with MM 3, does not work with MM3 !?!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
Got a Beta of 1.7.7, and it works fine now...
