How to Sort MM database table within a script

This forum is for questions / discussions regarding development of addons / tweaks for MediaMonkey for Windows 4.

Moderators: Gurus, Addon Administrators

Posts: 97
Joined: Thu Oct 11, 2018 4:48 pm
Location: USA, Pacific Northwest

How to Sort MM database table within a script

Post by pokeefe0001 »

I mistakenly posted a question in the "Need Help? (MMW4)"viewtopic.php?t=103686 when it should have been posted here, so this is a multiple posting. Sorry.

I have a script that accesses the entire Songs table my first selecting Music in the media tree, performing whatever sort I wish, and running the script containing

Code: Select all

Set list = SDB.AllVisibleSongList
I would rather do the sort in the script so the correct sort gets performed regardless of what has been in the media tree. I suspect there is a standard SQLite call to do this, but I'm not fluent in SQLite access from VBS (or from anywhere else for that matter). How do I programmatically perform a sorted extraction of data from the database?
MMV4 (1919) Portable
MMW5 (2606) Portable
Multiple Win11 x64 21H2
Multiple Win7 x32, unknown builds