by grillmeister7 » Fri Dec 17, 2010 1:42 pm
Sorry to be a pest; you have been most helpful. I beg you indulgence but I wasn't clear enough. The first construct yielded over 11,000 records which was unwieldy.
My ultimate goal is to have a copy of all songs I've rated in my main library folder.
This latest code gives me songs that have any copy in the library rated 2-1/2 stars or more
but are not stored in the "O:\Audio files" (Main library) folder yet all the ones I checked also had a copy in the "O:\Audio files" folder:
Code: Select all
<Group|name:Tracks...|Show tracks:No>\Any duplicates where at least one track is rated 2.5 stars or more and not in music folder|Icon:Top level|Filter:Songs.SongTitle || '@' || Songs.Artist COLLATE IUnicode IN (SELECT SongTitle || '@' || Artist COLLATE IUnicode AS GroupField FROM Songs GROUP BY GroupField HAVING Count(*) > 1 AND Max(Rating) > 49) AND <Folder> Not Like 'O:\Audio Files\%'\<Title|Trim:1>\<Title with artist>
I want to find the tracks for which at least one of the copies of the track is rated 2-1/2 stars or more
but has no tracks in the main library folder ("O:\Audio files") so I can move it to the main folder.
Ex. If The Platters 'The Great Pretender', rated 3 stars, doesn't have a copy in the 'O:\Audio files' folder but does have a copy in the "O:\Extra Music file Copies 2" folder (and/or a folder on another drive), that should appear in the result.
Ex. If Buddy Holly's 'Rave On, rated 3-1/2 stars has a copy in "O:\Audio Files', it should not appear in the result regardless of whether there is a copy in any other folder.
Sorry to be a pest; you have been most helpful. I beg you indulgence but I wasn't clear enough. The first construct yielded over 11,000 records which was unwieldy.
My ultimate goal is to have a copy of all songs I've rated in my main library folder.
This latest code gives me songs that have any copy in the library rated 2-1/2 stars or more [u]but are not stored[/u] in the "O:\Audio files" (Main library) folder yet all the ones I checked also had a copy in the "O:\Audio files" folder:
[code] <Group|name:Tracks...|Show tracks:No>\Any duplicates where at least one track is rated 2.5 stars or more and not in music folder|Icon:Top level|Filter:Songs.SongTitle || '@' || Songs.Artist COLLATE IUnicode IN (SELECT SongTitle || '@' || Artist COLLATE IUnicode AS GroupField FROM Songs GROUP BY GroupField HAVING Count(*) > 1 AND Max(Rating) > 49) AND <Folder> Not Like 'O:\Audio Files\%'\<Title|Trim:1>\<Title with artist>[/code]
I want to find the tracks for which at least one of the copies of the track is rated 2-1/2 stars or more [u]but has no tracks in the main library folder ("O:\Audio files") [/u]so I can move it to the main folder.
[i]Ex. If The Platters 'The Great Pretender', rated 3 stars, doesn't have a copy in the 'O:\Audio files' folder but does have a copy in the "O:\Extra Music file Copies 2" folder (and/or a folder on another drive), that should appear in the result.[/i]
[i]Ex. If Buddy Holly's 'Rave On, rated 3-1/2 stars has a copy in "O:\Audio Files', it should not appear in the result regardless of whether there is a copy in any other folder.[/i]