Quote
spacerspacer

 trouble using combined AND / OR

Questions
redline
 
hi,

I am trying to combine an AND and an OR clause in my SPL but seem to have problems. eg, I want to a SPL that combines all genres of jazz and funky and has a rating >= 4.

My mind says:

genre = jazz
OR
genre = funky
AND 
rating >= 4


But iTunes only lets me use either, not both, AND / OR

For example, by using "Match All" I effectively get:

genre = jazz
AND
genre = funky
AND
rating >= 4


This produces a blank list as i have not genres that contain both funky AND jazz

Alternatively, by using "Match Any" I get the same as:

genre = jazz
OR
genre = funky
OR 
rating >= 4


This produces an incorrect list as songs with genre not equal to jazz or funky will get selected if the are rated >= 4.

Obviously neither of the above will work and I dont want to use the "limit to X songs ranked by highest rating" either as I often dont have X songs that are > 4 stars so by using this feature I get < 4 star songs that i dont want in the list.

Am I missing somthing really basic or does iTunes have a very weak database search functionality?


by dblife on May 01, 04 | 8:00 am
redline


Comments

This can be solved with a new feature in iTunes 4.5- "playlist is"

You can now base playlists on other playlists. A cumbersome workaround for and/or functionality.


by dfbills on May 03, 04 | 10:04 am

To elaborate a bit:

Make one playlist like this:

genre = jazz
AND
rating >= 4

and another one like this:

genre = funky
AND
rating >= 4

And use a third playlist to pick each song that is in playlist 1 or playlist 2.


by Baumi on May 03, 04 | 10:11 am

There's a slightly nicer way to do this that requires only one "clutter" playlist, not two (i.e. a total of two, not three):

Playlist A:
Match ANY:
Genre - is - jazz
Genre - is - funky

Playlist B:
Match ALL:
Playlist - is - Playlist A
Rating - is greater than - 3 stars

Playlist B is the one you play =)


by nyorker on May 03, 04 | 2:31 pm

thanks guys/girls.

unfortunately I cant get to I tunes for a few weeks to test it out but will do once I can.

I actually suggested to Apple a while ago that they allow PL's based on other PL's. nice to see they listen. Although a simple AND/OR functionality wouldn't be too much to ask. :)


by dblife on May 10, 04 | 4:26 pm

You must be logged in to post comments.

  USERS  
  Log-In  
  Register  

try this
red line
 
 


comments
red line
 
 
red line
sites we like
red line
 
 

XML/RSS Feed

Powered by pMachine