I'm with the users above... I think autoplaylists is one of the best features of Mediamonkey and it has made listening to the music I want to listen to very easy. But now I want to be able to do more... for instance:

I would like to make a 'Best Album by a New Artist (2005)' autoplaylist that would show me the highest rated album that meets the following criteria:
- Year = 2005
- # of songs on the album > 5
- Artist does not have any albums released before 2005 (hence a new artist)

I accomplished this using the SQL query at the bottom of the post and made a magic node for it, but magic nodes can't be synced to portable devices.

Jiri, any chance of adding an SQL parameter as an advanced option for autoplaylists?

Thanks,
-John


Best Album by a New Artist (2005) query:
SELECT Songs.ID, Songs.SongTitle
FROM Songs
WHERE (((Songs.IDAlbum) In (SELECT top 1 Songs.IDAlbum FROM (Songs INNER JOIN Artists ON Songs.IDArtist = Artists.ID) INNER JOIN Albums ON Songs.IDAlbum = Albums.ID GROUP BY Artists.Artist, Albums.Album, Songs.Year, Songs.IDArtist,songs.IDAlbum
HAVING (((Songs.Year)=2005) AND ((Count(Songs.IDAlbum))>5) AND ((Songs.IDArtist) Not In (select distinct idartist from songs where year <2005)))
ORDER BY Avg(Songs.Rating) DESC)))
ORDER BY Songs.SongOrder;

Ideally, auto-playlists would be capable of using 'sub-criterias' for their search. For example, I would be able to create a playlist that included 'Rock' Songs from before 1980 plus 'Blues' songs after 1960. The year criteria being a subset of each particular genre.

jiri wrote:It is planned for 2.5 to add new options to Advanced queries and so this will be hopefully added.

Jiri

Great! I'd love to see the AND and OR qualifiers added, along with (grouping) with parentheses. Or perhaps an option to directly edit the query being generated?

jiri wrote:It is planned for 2.5 to add new options to Advanced queries and so this will be hopefully added.

Jiri

Cool, I'm really looking forward to.

It is planned for 2.5 to add new options to Advanced queries and so this will be hopefully added.

Jiri

onkel_enno wrote:Please add the "is not" Option for Mood, Temp, Occasion, ...
If not, please let me select Tracks were the Temp, Mood, ... isn't filled yet.

@Jiri
Will that be done in 2.5? It shouldn't be to difficulty to implement but would help much! Thanks

Please add the "is not" Option for Mood, Temp, Occasion, ...
If not, please let me select Tracks were the Temp, Mood, ... isn't filled yet.

Using artist comment field in advanced queries seems to be a good idea, I believe we'll fit it into the next version.

Jiri

You can choose the comment field as a property from the advanced tab in autoplaylist. just type indie in the value & there you have it. Any song which you put indie in the comment field will appear in the result of this autoplaylist in the future.

I'd like auto playlists to be able to use fields outside of the fields associated with tracks. In particular, I'd like to be able to add words to an artist's comment field, and use that in creating an auto playlist.

So, for example, if I put "indie" in the artist's comment field, then all the songs by artists with the word "indie" in their comment field will appear in the auto playlist.

Now, before you reply to this post, please know that I do realize I can create auto playlists based on artist name. Personally, I find this method of auto playlist time consuming. This is why: if I'm listening to DMB, it may dawn on me that I'd like to have them in my auto playlists that I've created for "World Cafe" and for "Cities 97". I may have already done this, but I can't be sure. In order to find out, I have to browse to each playlist seperately and dig into each playlist's properties and then dig further to find DMB in the list to see if has a checkmark next to it.

Instead I'd rather go to "Find more of the same... Artist", choose the artist properties and see much faster which keywords I've set up in the comment field.