You mentioned Organized and Unorganized folders first, and now you are talking about Unsorted folder, so I am a little bit confused. It would be best if you specified your real folders. Is "N:\Music\Artists" your real folder? Do you really have "Artists" in its name or you think that that should be replaced by add-on with specific artist names?
By the way, you should always end folders with "\". It will work even without it since it is followed by the '%' wildcard character, but it could lead to the incorrect results in some rare cases. Also, you ended up your folder string with the mentioned wildcard character even when I already had it in the query, i.e. you had it duplicated.
Further more, your mask has specified Filter:<Path> LIKE 'V:\Reconcile\Music%' on the group level, which apply to all Magic nodes belonging to that group, so you cannot have displayed tracks from another folders then that at all. If you can, please report since it would be a bug.
The query that I mentioned is unnecessary complicated, it could be replaced with just:
Code: Select all
<Folder> NOT LIKE 'your_Organized_folder_with_\_on_the_end%'
It will return all tracks that are not on the specified base folder, but if you have artists with tracks on that and another folders, then it will display tracks from these another folders anyway.
If you want to get only artists that don't have tracks on the specified base folder at all, even if they have tracks on another base folders, maybe you could try this:
Code: Select all
<Album Artist> NOT IN (SELECT Artists.Artist FROM Songs INNER JOIN ArtistsAlbums ON Songs.IDAlbum = ArtistsAlbums.IDAlbum INNER JOIN Artists ON ArtistsAlbums.IDArtist = Artists.ID LEFT JOIN (SELECT *, CASE WHEN DriveLetter IS NOT NULL THEN SubStr('ABCDEFGHIJKLMNOPQRSTUVWXYZ', DriveLetter + 1, 1) ELSE '' END AS DriveStr FROM Medias) AS Medias2 ON Songs.IDMedia = Medias2.IDMedia GROUP BY Artists.Artist HAVING Min(InStr(<Path>, 'your_Organized_folder_with_\_on_the_end')) > 0)
With this filter you should not have the wildcard character on the end of folder.
If you are still not getting what you wanted, please specify more examples with full path of files that you want and files that you don't want to get displayed. Screenshots are also recommended.