Jump to content

Filtering for is null or empty fields?


MBSki

Recommended Posts

MBSki

I'm trying to find files that are missing data for certain data fields. Right now I'm looking for videos that don't have a Parental Rating. I don't see any way to filter on a Parental rating of IsNull or empty. Is there a way to do this in any app? I've tried the web app and Android mobile, but neither app has the option to filter on empty fields.

Link to comment
Share on other sites

No way to do that as a filter that I'm aware of but you could do this and might prefer it.

Load the Reports Plugin from the Plugin Catalog.

You can then use this to export your media to CSV or Excel formats.

Once in Excel or Open Office Spreadsheet you can sort by the Parental  Rating column.

  • Thanks 1
Link to comment
Share on other sites

MBSki

@cayars This is awesome, thanks! I actually don't even need to export. The filter I need is right there in the GUI. 😁

  • Like 1
Link to comment
Share on other sites

Yes, it's nice for things like this.

It's also nice to have a complete export of your media "just in case" you ever loose a drive or something without backup and want to know what was lost.  Lots of uses for the data.

  • Like 1
Link to comment
Share on other sites

This would be a good filter to add to the standard filters so that you can do this without the reports plugin. Thanks for the feedback.

  • Like 2
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...