VoxCommando

Help and Support (Using VoxCommando) => MediaMonkey => Topic started by: igvk on June 10, 2017, 04:32:35 PM

Title: Custom SQL select
Post by: igvk on June 10, 2017, 04:32:35 PM

Is it possible to select songs with MM plugin, so that the SQL statement uses other tables from MM?
Such as, for example:

Code: [Select]

SELECT Songs.Id, Songs.SongTitle
FROM Songs, PlayListSongs, PlayLists
WHERE Songs.Artist = 'Artist'
AND Songs.Id = PlayListSongs.IdSong
AND PlayListSongs.IdPlayList = PlayLists.IdPlayList
AND PlayLists.PlayListName = 'Playlist'
ORDER BY PlayListSongs.SongOrder


Title: Re: Custom SQL select
Post by: nime5ter on June 11, 2017, 10:40:38 AM

No, not at the moment. This is a feature James will investigate. We are currently away from the office, so it may take several weeks.

There is only the  MM.LoadBySQL (http://voxcommando.com/mediawiki/index.php?title=Plugin_MM#LoadBySQL) action, which allows you to customize the "Where" parameters in order to load and play songs.

Are you asking whether you can load song, or do you want to generate a payload XML file?

Title: Re: Custom SQL select
Post by: igvk on June 12, 2017, 07:08:36 PM

I am interested in playing songs in a specific order, and that order is manually set in the playlist.
This is not about generating XML.