Page 1 of 1

Recently played songs

PostPosted: Wed Oct 28, 2015 11:55 am
by Wolke
Hello everyone,

I am wondering if there is any way to retrieve a list of recently played songs. On the WebApp I can only find recently played albums. I accidently cleared the playlist that was playing last night and I would like to restore it. If there is no function for that, maybe it would be possible to look into the database of the server?

In general I think it would be a nice feature to be able to see no just what everyone is listening to right now, but to display a history of that as a list.

Re: Recently played songs

PostPosted: Fri Nov 13, 2015 9:12 am
by Wolke
In case you are the only one using your server or it hasn't been long since playing the files, I found the following solution:

1. Instead of "yourserverurl:4040/index.view" go to "yourserverurl:4040/db.view"
2. Type in: SELECT TOP 200 artist, title, album, last_played FROM media_file WHERE type = 'MUSIC' ORDER BY last_played DESC
3. Hit OK

This gives you a list of the recently played files.

Re: Recently played songs

PostPosted: Fri Nov 13, 2015 3:33 pm
by Squabsy
Thats Great & very interesting - is there a guide to using the DB view or at least a list of queries to use ?

Re: Recently played songs

PostPosted: Sat Nov 14, 2015 12:05 pm
by Wolke
There is just a set of tables that I found can be accessed:

User Tables: user | user_role | user_rating | bookmark | user_settings
Media Tables: artist | album | media_file | music_file_info | genre | music_folder | playlist | playlist_file | internet_radio | podcast_channel | podcast_episode
Starred Tables: starred_media_file | starred_album | starred_artist
System Tables: role | share | share_file | Player | Player_transcoding | Player_transcoding2 | transcoding | transcoding2 | custom_avatar | system_avatar | version