Ability to purge all completed requests in a single action

[Weavus]

I'd like to be able to delete all completed requests with a single action rather than having to do them all manually. In fact, I think having a separate 'Completed Requests' alongside the 'Recent Requests' list on the homepage would also be nice...

[sct]

May I ask why you want to purge your completed requests? Overseerr by design is meant to keep a request history, so the option to mass delete isn't available. Deletion is mainly to reset state to allow something to be requested again.

[Weavus]

I appreciate the design decision of keeping all request history so maybe what I'm after is a way to filter out completed requests or list them in a separate place as once you get a few hundred requests the single Requests lists gets a bit muddled with the mix of completed or outstanding requests in my opinion. As an admin I'm mainly concerned with what's still outstanding and I get told about completed requests by notifications anyway.

[sct]

I hear you. That’s why we have an issue for that :) #431

[lazynooblet]

I don't care for keeping request history. I have recently purged 50% of items, and wanted all the history of requests that had been fulfilled to be removed, allowing users to re-request should they please.

Running this on the SQLite database worked for me.

DELETE FROM media_request WHERE id IN (SELECT media_request.id FROM media LEFT JOIN media_request ON media.id = media_request.mediaId WHERE media.status=5);

[ericvlog]

I don't care for keeping request history. I have recently purged 50% of items, and wanted all the history of requests that had been fulfilled to be removed, allowing users to re-request should they please.

Running this on the SQLite database worked for me.

DELETE FROM media_request WHERE id IN (SELECT media_request.id FROM media LEFT JOIN media_request ON media.id = media_request.mediaId WHERE media.status=5);

it this working on latest overseerr ? I get in sql and execute the command seem is unable to delete now.