Reset/Edit "Recently Played"

General discussions.

Moderator: moderators

Reset/Edit "Recently Played"

Postby cds1 » Wed Oct 13, 2021 1:46 pm

Is it possible to edit the content in "Recently Played"? I use the songs listed in Recently Played to quickly and easily find music while running. Occasionally, songs get played that I don't want to hear again. If songs can't be removed, can I reset them?
Posts: 7
Joined: Sat Aug 20, 2011 2:37 pm

Re: Reset/Edit "Recently Played"

Postby Squabsy » Fri Oct 15, 2021 6:50 pm

it's getting less and less possible to do anything Subsonic is dead try Navidrome instead
Posts: 6
Joined: Thu Aug 22, 2013 12:57 pm

Re: Reset/Edit "Recently Played"

Postby acroyear » Mon Oct 18, 2021 4:52 pm

it wouldn't matter how much this is supported. it isn't really a common use-case at all as such. Plex is one of the very few systems that allows one to 'forget' having seen it before. Youtube can do it as well but the interface is really hard to find.

in any case, go to <server>/db.view

Code: Select all
select * from media_file where type = 'MUSIC' order by last_played desc limit 50;

that will bring up the last 50 songs that have been played (note: no matter who has played them - this is a global setting, not a personal one)

write down the IDs, and re-enter them in a query like the following. the id's are in the parens, separated by comma
Code: Select all
update media_file set last_played = null where id in (156167, 113951)

there won't be any feedback after hitting OK. simply re-run the first query and you should see them removed from the list.
Joe Shelby
User avatar
Posts: 774
Joined: Wed Mar 27, 2013 8:05 pm
Location: Northern, VA

Return to General

Who is online

Users browsing this forum: No registered users and 8 guests