Serviio

I like the categories "Recent Unwatched", it's the main presentation category I've used for years.

But if I add a complete new folder to the library (and it's all watched) or renamed, it plagues my Recent Unwatched list making it useless.

Or if I watch items via a different source (Netflix, TV, etc). I would love to be able to edit the Watched/Unwatched status.

Until now I manually connect to the Derby database and run SQL to update Watch Count.

It seems like something that could/should be provided through the front end?

Hey. In general, the template for changing the SQL text looks like this: C / OLD / NEW, where C is an abbreviated version of the CHANGE command and allows you to change the first occurrence of the specified text in the current line, OLD is the actual SQL text that you want to change, and NEW - SQL text that needs to replace old text. The listing below demonstrates the use of pattern matching technology to perform text replacement in a SQL * Plus session.

Thanks Commaking, I'll use it out of desperation next time I'm in there.

Until now I manually connect to the Derby database and run SQL to update Watch Count.