[mythtv-users] Power search record exclude shows

Thomas Boehm mythtv-users at lists.boehmi.net
Fri Aug 26 22:09:50 UTC 2011

Jan Ceuleers wrote:
> If the list of shows to be excluded is getting a bit too long (for 
> example a power search record rule matching movies on multiple channels 
> and you don't want to record movies you already have on DVD), then you 
> can add something like
> AND NOT lower(program.title) IN (SELECT lower(title) FROM theDVDsIvegot)
> Then you just create a table called theDVDsIvegot within mythconverg 
> with a title column, and add all of your DVD titles to it.

I asked a similar question some time ago and got this solution

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

Of course, all your DVDs need to be ripped to your hard disk to get this


More information about the mythtv-users mailing list