User Tools

Site Tools


playlists_sql_examples

PlayLists Active SQL Examples

Active SQL Playlists are a very flexible way of managing your playlists. They are Playlists that will automatically execute/update each time you select them giving you ability to filter and grab tables dynamically.

Here are some sample of Playlists and the SQL you can set to use them:

some threads:

https://vpinball.com/forums/topic/sql-playlists/

https://vpinball.com/forums/topic/sql-helper-for-pinballx-users-going-to-pinup-menu/

- Based on GameType, list all DMD (and color DMD) games:

SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE (GameType= "DMDc" or GameType= "DMD") ORDER BY GameDisplay

- Using the TAG “ignore” remove certain games from any list:

SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE (GameType= "DMDc" or GameType= "DMD") and tags not like "%ignore%" ORDER BY GameDisplay

- Playlist for Pinsound tables (using field LaunchCustomVar)

SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE ( LaunchCustomVar LIKE "%pinsound%" or LaunchCustomVar LIKE "%altsound%") and TAGS NOT LIKE "%ignore%" ORDER BY "GameDisplay"

- Playlist for adult games:

select * from games JOIN Emulators on Games.EmuID = emulators.EmuID where TAGS LIKE "%adult%" and TAGS NOT LIKE "%ignore%" ORDER BY "GameDisplay"
playlists_sql_examples.txt · Last modified: 2018/08/05 15:35 by 173.34.89.140