Plex-Tampermonkey-Scripts icon indicating copy to clipboard operation
Plex-Tampermonkey-Scripts copied to clipboard

Feature Request: Add a field to edit the Date Added

Open raddacle opened this issue 4 years ago • 11 comments

I've had to edit the Date Added from SQLite for a long time, and it would be incredible if that could be done directly from Plex. This could allow easy customization of the Recently Added rows.

raddacle avatar Jan 11 '21 00:01 raddacle

I can take a look at this, not sure if it would work thought. What exactly is the column name in SQLite? and what is some example data for that column? how does it store the date?

denniskalpedis avatar Jan 22 '21 14:01 denniskalpedis

The column is named added_at in the table metadata_items.

For example if I were to change the added date of an item I'd first figure out the id of the item and then run the following query: UPDATE metadata_items SET added_at = 'YYYY-MM-DD HH:MM:SS' WHERE id='####';

keldian avatar Feb 28 '21 17:02 keldian

just wondering, why do you need to edit the date added value?

dauheeIRL avatar Jun 30 '23 10:06 dauheeIRL

To change the timestamp of when the item appears to have been added to Plex, on the Plex interface?

keldian avatar Jun 30 '23 10:06 keldian

am wondering what the benefit of this is? There are quite a few ordering options for libraries in plex

dauheeIRL avatar Jun 30 '23 10:06 dauheeIRL

Libraries, maybe, but the Recently Added sections are always ordered by date added, and those sections are usually the first thing a user sees when they open Plex.

keldian avatar Jun 30 '23 10:06 keldian

I don't see the need/benefit for this request. There are advanced filter and sorting options already with PLEX

dauheeIRL avatar Jun 30 '23 10:06 dauheeIRL

I just explained to you that those filtering and sorting options are not available for the Recently Added sections, but you're certainly free to see or not see what you like buddy.

keldian avatar Jun 30 '23 10:06 keldian

lets get back to basics buddy. What's the purported benefit to modifying the date added for content?

dauheeIRL avatar Jun 30 '23 11:06 dauheeIRL

In certain situations, when files are relocated, Plex may not just update the file location but instead remove the content from the interface and then re-add it. This process can cause older content to appear in the Recently Added section, which is typically where users look for new content on the server.

Additionally, if I were to add missing episodes of an older show to the server, I wouldn't want these minor corrections to be displayed and clutter the Recently Added section.

raddacle avatar Jun 30 '23 15:06 raddacle

for point #1 Too infrequent, doesn't warrant userscript - a more fitting method would be to run via SQL - also benefit of doing a mass update and not having to do each individually which could be a LOT. FYI if doing a library change, best to edit the location in the backend instead of doing a complete rebuild and lose the infrequent tweaks that may be required on things like posters, incorrect matching etc - there are some good tutorials on that

for point #2, it is literally the WHOLE point of Recently Added section to show what has been recently added. It wasn't there, now it is . . .

Tampermonkey absolutely rocks, but just because it can do something, doesn't mean it should. Feature requests should be submitted to PLEX for features that improve and enhance the product - so that ALL users can benefit, not just those lucky enough to have found this script for Tampermonkey. Some requests go against PLEX design principles (i.e. direct link to 3rd party content rating sites), which is where the power of Tampermonkey kicks in

dauheeIRL avatar Jun 30 '23 16:06 dauheeIRL