Custom SQL select

[igvk]

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 Expand

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


[nime5ter]

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 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?

[igvk]

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.