[mythtv-users] Record only shows which don't exist in the video database

[Thomas Boehm]

Hi all,

I try to setup a custom rule which should record movies from certain actors, but only if they don't exist in my video database. The first part is quite easy and works, but I'm struggling with the test whether a movie already exists or not. 

I tried the following

(... bla bla ...) AND program.title NOT LIKE videometadata.title

This gives me the following SQL error

"
Error:
There is an error in your custom SQL query:

Unknown column 'videometadata.title' in 'where clause' [#1054]
..."

Is there a way to do this? Obviously I'm not am SQL expert ;-)

Thanks
Thomas