[mythtv-users] Conditional custom recording rule

[Ian Evans]

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

>
> On Mon, Oct 6, 2014 at 8:37 PM, Ian Evans <dheianevans at gmail.com> wrote:
>
>> 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%'
>>
>
>
> Maybe:
>
> " program.title = 'Evening News' AND program.chanid=1665 AND
> TIME(program.starttime,'Etc/UTC', 'SYSTEM')) = '18:00:00' AND pother.title
> <> 'CTV News' AND pother.chanid=1665 AND TIME(pother.starttime,'Etc/UTC',
> 'SYSTEM')) = '18:00:00' "
>
> With Additional Tables set to: ", program pother"
>
> Don't forget that leading comma in the Additional Tables.
>
> I did test that sample the screenshot came from and it seemed to work.
>
>
I hate when someone's working test fails on my system with a straight copy
of the same thing. :-)

Just a couple of notes:

1) Did you mean TIME(CONVERT_TZ(program.starttime,'Etc/UTC', 'SYSTEM'))
instead of  TIME(program.starttime,'Etc/UTC', 'SYSTEM'))?

2) I'm assuming the chanids shouldn't both be 1665?

Thanks so much for putting yer thinking cap on.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20141007/c0fd84da/attachment.html>