[mythtv-users] Conditional custom recording rule

[Ian Evans]

On Mon, Oct 6, 2014 at 5:36 PM, John P Poet <jppoet at gmail.com> wrote:

> On Mon, Oct 6, 2014 at 2:25 PM, Ian Evans <dheianevans at gmail.com> wrote:
>
>> First off, I'd like to thank Hika, Stephen and Nicolas (and anyone else
>> who'll be jumping in) for looking at this. The fact that we can even toss
>> this around shows how great MythTV is as compared to the STBs offered by
>> the cable and sat companies.
>>
>> I guess it's really an exercise in laziness. :-) I could just have a rule
>> for the backup newscast set at a lower priority, but I like to keep my
>> conflict list free of priority conflicts (I only occasionally get them) so
>> that when I look I see the real conflict choices between two classic movies
>> or docs.
>>
>> I see here (http://www.mythtv.org/wiki/Custom_Recording) that nested
>> selects work. But do if/then/else phrases?
>>
>> This is not valid sql or mythtv obviously but the logic might be:
>>
>> IF (select title='CTV News' and time='6pm') = 0 THEN schedule Global News
>> at 6pm
>>
>
> You can create a Custom Record Rule which uses multiple references to
> programs.  The 'Additional Tables' just needs filled in to let it know that
> you want to base your rule off of another "program".  See the attached
> screenshot for an example (hopefully you can read it, since I had to save
> it at an extremely low quality).
>
>
>
After my first attempt didn't work, I've been staring at this all night. :-)

Ok, so the usual news show is called simply "CTV News" and airs on 1662 at 6

The backup news show is called simply "Evening News" and airs on 1665 at 6.

I tried changing the backup shows title match to an '=' and not a LIKE.
Still no go. Scratching my head. Current SQL:

program.title = 'Evening News' AND
HOUR(CONVERT_TZ(program.starttime,'Etc/UTC', 'SYSTEM')) = 18 AND
pother.chanid=1662 AND pother.starttime = program.starttime AND
pother.title NOT LIKE 'CTV NEWS%'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20141006/6b9a69df/attachment.html>