Recently played songs

General discussions.

Moderator: moderators

Recently played songs

Postby Wolke » Wed Oct 28, 2015 11:55 am

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.
Wolke
 
Posts: 9
Joined: Wed Oct 28, 2015 11:46 am

Re: Recently played songs

Postby Wolke » Fri Nov 13, 2015 9:12 am

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.
Wolke
 
Posts: 9
Joined: Wed Oct 28, 2015 11:46 am

Re: Recently played songs

Postby Squabsy » Fri Nov 13, 2015 3:33 pm

Thats Great & very interesting - is there a guide to using the DB view or at least a list of queries to use ?
Squabsy
 
Posts: 4
Joined: Thu Aug 22, 2013 12:57 pm

Re: Recently played songs

Postby Wolke » Sat Nov 14, 2015 12:05 pm

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
Wolke
 
Posts: 9
Joined: Wed Oct 28, 2015 11:46 am


Return to General

Who is online

Users browsing this forum: No registered users and 2 guests