[mythtv-users] Should Videos be considered Recorded?

[Michael T. Dean]

On 05/22/2013 10:41 AM, Thomas Boehm wrote:
> Raymond Wagner wrote:
>> On 5/22/2013 9:50 AM, Thomas Boehm wrote:
>>> Title: Actors
>>> Additional Tables: , people, credits
>>> Search Phrase: people.name REGEXP '^Actor1$|^Actor2$|^Actor3$|^Actor4$'
>>> AND credits.person = people.person AND program.chanid = credits.chanid
>>> AND program.starttime = credits.starttime AND program.title NOT IN
>>> (SELECT DISTINCT title FROM videometadata)
>>>
>>> Maybe you can use it for your custom recording rule.
>>>

The OP asked for a way to mark showings of movies in his Video Library 
as previously recorded so that they would appear in MythWeb as having 
been recorded so he knows not to create rules to record them.  This does 
not do that.

So, really, he'd be better off doing a custom recording rule that's the 
logical opposite of:

>>> program.title NOT IN
>>> (SELECT DISTINCT title FROM videometadata)

and then setting the rule to inactive.  Then, on MythWeb's Upcoming 
Recordings page, it will show as a match, but not recording due to the 
inactive rule.  Then, once every couple of weeks, he can go through 
Upcoming Recordings and click on all the movies that have matched the 
inactive rule and verify that the movie is the one he already has and 
"Never record" them.  So, basically, the 2nd paragraph of my first 
post...  http://www.gossamer-threads.com/lists/mythtv/users/544009#544009

>> Which comes right back to what Mike said previously about false
>> positives on every movie with a duplicate title, which is specifically
>> why MythTV uses more than just the title for duplicate matching.
> I can live with that. How likely is it that there are two movies with
> the same title AND any of my few favourite actors in it?

Actually, two programs...  You never told MythTV to limit the rule to 
movies.

Mike