Author Topic: play artist excluding....  (Read 2260 times)

0 Members and 1 Guest are viewing this topic.

OklahomaGreyBeard

  • Contributor
  • ***
  • Posts: 54
  • Karma: 3
    • View Profile
play artist excluding....
« on: May 02, 2015, 07:58:09 PM »
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

  • Administrator
  • Hero Member
  • *****
  • Posts: 2012
  • Karma: 61
    • View Profile
    • Getting Started with VoxCommando
Re: play artist excluding....
« Reply #1 on: May 03, 2015, 09:45:30 AM »
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.



TIPS: POST VC VERSION #. Explain what you want VC to do. Say what you've tried & what happened, or post a video demo. Attach VC log. Link to instructions followed.  Post your command (xml)

OklahomaGreyBeard

  • Contributor
  • ***
  • Posts: 54
  • Karma: 3
    • View Profile
Re: play artist excluding....
« Reply #2 on: May 03, 2015, 10:05:44 AM »
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

  • Administrator
  • Hero Member
  • *****
  • Posts: 7714
  • Karma: 116
    • View Profile
    • VoxCommando
Re: play artist excluding....
« Reply #3 on: May 03, 2015, 12:40:40 PM »
Try this:

Code: [Select]
Artist ="{1}" and Not Genre like "%Holiday%" order by random() limit 100

jitterjames

  • Administrator
  • Hero Member
  • *****
  • Posts: 7714
  • Karma: 116
    • View Profile
    • VoxCommando
Re: play artist excluding....
« Reply #4 on: May 03, 2015, 12:42:16 PM »