Plex search based on missing tag

General Discussions
1

Hi,

I’d like to see which of my movies are missing the COUNTRY tag so I can fill them in. However, as soon as I attempt to search, I am unable to sort movies by COUNTRY; I actually have to specify a COUNTRY string. I tried leaving it empty as well as double quotes but this doesn’t appear to work.

Is there any way to search or sort or list movies based on a non-existing tag?

Thanks.

2

Well, there was a way you could get there using custom filters, but the necessary features seem to be broken right now.

I don’t think there is/was a way to say “show me all movies where ‘Country’ is empty,” but you could say “Show me all movies where ‘Country’ is NOT x or y or z.” You’d have to build a list of all the countries that do exist in your collection in order to exclude them, but you could do it.

Unfortunately, “is” and “is not” operators don’t seem to be working right now.

It would be nice if ‘is not empty’ were an option, but I don’t think it is.

3

Ended up accomplishing this with SQLITE with this syntax:

SELECT title,year FROM metadata_items WHERE library_section_id=3 AND tags_country IS ‘’;