Thank you erland, you're gem!
Here is my final code:
Code:
-- PlaylistName:Goldberg Variations
-- PlaylistGroups:
-- PlaylistOptionDontRepeatTracks:1
-- PlaylistOptionUnlimited:1
select tracks.url from tracks
join contributor_track on
PatLogan;525917 Wrote:
but... I'd like to sort the items by genre. I tried to link the genre
tables but did not succeed, if u can help...
Cheers :)
Pat
Try something like this:
Code:
-- PlaylistName:Goldberg Variations
-- PlaylistGroups:
select tracks.url
Hi erland,
thx for your precious help.
this works:
Code:
-- PlaylistName:Goldberg Variations
-- PlaylistGroups:
select tracks.url from tracks
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
I think this is the documentation that exists:
http://wiki.slimdevices.com/index.php/SlimServerDatabaseStructure
The track name are stored in tracks.title and the track number is
stored in tracks.tracknum
Your sample doesn't really match your description of what you want to
do. Your sample
Hi there,
Is there the scheme of the database anywhere ?
I'd like to customise a query on track name and track number but I
don't find how to do this.
Here is my example:
Code:
-- PlaylistName:Goldberg Variations
-- PlaylistGroups:
select tracks.url from tracks