Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Use SQL to Update Plex Recently Added List. and this video is uploaded by Jason at 2019-01-31T08:27:49-08:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [Z0gCEJkJ0hk]
| Name | Use SQL to Update Plex Recently Added List |
| Video Uploader | Video From Jason |
| Upload Date | This Video Uploaded At 31-01-2019 16:27:49 |
| Video Discription | This is how I control what is in Recently Added on Plex. Sometimes I exclude movies from being updated. -- Order by date added SELECT id, title, added_at, originally_available_at, refreshed_at, updated_at, deleted_at, changed_at FROM metadata_items WHERE library_section_id = 1 -- 1 is for Movies 2 is for TV shows AND metadata_type = '1' -- 1 is for Movies ORDER BY added_at DESC; -- Sets date added to the originally available date UPDATE metadata_items SET added_at = originally_available_at where metadata_type = '1' -- IMPORTANT!! --AND id != [Z0gCEJkJ0hk] |
| Category | Education |
| Tags | Plex Recently Added SQL |
