Author Topic: Custom SQL select  (Read 1985 times)

0 Members and 1 Guest are viewing this topic.

igvk

  • Jr. Member
  • **
  • Posts: 17
  • Karma: 0
    • View Profile
Custom SQL select
« 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

nime5ter

  • Administrator
  • Hero Member
  • *****
  • Posts: 2012
  • Karma: 61
    • View Profile
    • Getting Started with VoxCommando
Re: Custom SQL select
« Reply #1 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 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?

« Last Edit: June 11, 2017, 10:48:08 AM by nime5ter »
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)

igvk

  • Jr. Member
  • **
  • Posts: 17
  • Karma: 0
    • View Profile
Re: Custom SQL select
« Reply #2 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.