play artist excluding....

[OklahomaGreyBeard]

I love the play artist command but just ran across an issue. I say "Alexander, play artist Abney Park " and it does just that. However third song in it plays Winter Wonderland from one of their Christmas albums. Any way to exclude a specific genre from the play artist command since all my Christmas music is tagged Holiday in the genre field?

[nime5ter]

Yes, sure.

I don't know whether you've looked directly at the MediaMonkey commands yet. If you do, you'll see that they are using SQL queries to filter songs by various parameters. So you can customize them as you like.

[OklahomaGreyBeard]

Yea, I saw that and made my attempt at it, but I need to figure out MM's database setup. And then get some WD40 and spray it on my SQL skills that are rusted solid..  I guess this was more of an attempt to see if someone had already made a similar query.

[jitterjames]

Try this:

Code: [Select]

Artist ="{1}" and Not Genre like "%Holiday%" order by random() limit 100

[jitterjames]

..., but I need to figure out MM's database setup...

I suggest SQLiteSpy

http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index