Is this possible? For example, I have about 15 Content Rating filters to choose from but about 10 are empty. How do I remove this from the filter view?
They should clear out themselves after a few days.
If they are really not used anymore, by any item. Check collections, they might still have these ratings in them.
1 Like
@OttoKerner thanks, its been awhile for some… like a year.
How do I batch check collections, I have 603?
I have only found a way if you query the database directly with SQL.
SELECT title, content_rating FROM metadata_items WHERE guid LIKE 'collection%'
will give you a list of all collections and the associated content rating.
If you want to look for a content rating in particular, you can add an additional filter clause e.g.
SELECT title, content_rating FROM metadata_items WHERE guid LIKE 'collection%' AND content_rating LIKE '%tv-14%'
Modify the string between the last two % characters to pick a different rating.
If you leave out the first filter condition, you get a list of all items with a certain content rating: SELECT title, content_rating FROM metadata_items WHERE content_rating LIKE '%tv-14%'
For added comfort, you could use https://sqlitebrowser.org/ and a backup of the server database (get it in Plex Web under Settings - Manage - Troubleshooting)
1 Like
@OttoKerner, thank you! That did the trick. Damn collections 
Any thoughts on if Plex would try using Common Sense Media in the future? I had a ton of those from the plugin but the plugin was nuked a few years back.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
