Play Album Artist

[Diabl0570]

hello,

i want to change the commando play artist so that it plays the album artist instead of the artist.

i tryed edit the query but i coudn't figure it out.

this is the original query

Code: [Select]

Artist Like "{1}" order by random() limit 200
this is what i have so far:

Code: [Select]

Artist where AlbumArtists="{1}"  order by random() limit 200

found database structure on the media monkey wiki:

http://www.mediamonkey.com/wiki/index.php/MediaMonkey_Database_structure

but this is not correct,
cam some one help me a bit?

Thanks in advanced!

[jitterjames]

I am not 100% clear on the difference, but it seems that you can just replace the word Artist with AlbumArtist.

so instead of:
Artist Like "{1}"

write
AlbumArtist Like "{1}"

I don't know if you would need to adjust the artist xml file though since it is created based on artist, not album artist.

Probably you would need to add a few entries like "Various Artists", "Unknown" etc.

By the way if you are familiar with SQL, then you should know that the way the command works, there is a part at the beginning that is already implied.

"Select from songs where "

so what you were trying to do would end up with an SQL query like this:

"Select from songs where Artist where AlbumArtists="{1}"  order by random() limit 200

so you can see why it would not work...

[Diabl0570]

oh stupid:P

Code: [Select]

AlbumArtist="{1}"  order by random() limit 200worked indeed.

the reason i want to play the albumArtist is because i have a huge music data base.
a lot of numbers have as artist for example "eminem ft. jessica simpson" , i have set the albumArtist of these songs to eminem.
i want that if i say "play artist eminem" VC doesn't come up whit the alternatives like "eminem ft. jessica simpson" or "eminem ft. Dr. dre"
it just plays the songs whit eminem in it.

can i generate the AlbumArtist list somehow?
or is there a easier way to fix this?  

[jitterjames]

I will need to add a button in GenXML for AlbumArtist.

I was thinking about creating a more generalized command where you can create your own queries for creating xml files, but this would actually be a lot more work and then it wouldn't be part of the GenALLxml command, so for now I will just add another button.

[Diabl0570]

owh great thats perfect thank you very much!

thanks for your help!