Changing added_at field in metadata_items table in PLEX library db doesn't change episode sorting

Plex Media Server Metadata & Adding Files
,
1

This other thread (which is closed now) shows how changing the value of the [added_at] field of the [metadate_items] table in the PLEX library database using SQLite will result in this value used when sorting movies “By Date Added”.

I am trying to do something similar with TV show episodes and I am successfully updating the values (I can provide screenshots), but this has no effect when sorting these shows “By Last Episode Date Added”. Should I instead be changing some other field (maybe refreshed_at, changed_at or resources_changed_at) at either the show (show.metadata_type = 2) or season (metadata_type = 3) levels?

2

Does anyone know? So far, I have updated all of the following fields and they seem to make no difference at all when sorting shows by “Last Episode Added”

Seasons (metadata_items where metadata_type = 3):

  • added_at
  • updated_at
  • refreshed_at

Episodes (metadata_items where medatata_type = 4):

  • created_at
  • added_at
  • updated_at
  • refreshed_at

Media Items (media_items):

  • created_at
  • updated_at

Media Parts, files (media_parts):

  • created_at
  • updated_at

I’ve also explored a lot of other tables I see in the PLEX db and can’t figure out what the client is using to sort shows by “Last Episode Added”.

3

I think people who follow the Tatulli thread would know this. They also have a discord listed on their website.

1 Like
4

I never heard of Tautulli before, so thank you for pointing me there. I plan on installing and using it. However, I don’t know if I should post something that seems completely unrelated in either that thread or their Discord. They’ll probably remove it or tell me off. :no_mouth:

UPDATE: I went ahead and asked in their Discord server. We’ll see. Thanks!

1 Like
5

The Development - Plex Forum is also a good place to ask if the discord is quiet.

1 Like
6

Done. Thank you. Nothing from Discord yet.

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.