[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.
>
>
>
Ok...not sure if I found the fly in the ointment, Another CTV affiliate in
a nearby city calls their local 6pm news CTV News as well, though it's a
different newscast for a different city. I'm wondering if perhaps the
statement is detecting the _other_ CTV News at 6? My SQL foo is weak
tonight (bad headache...no sleep) but is the title locked to the chanid?

In other words is the statement locking the search for CTV News to only
that chanid? Is a WHERE needed somewhere?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20141007/f72bbd66/attachment.html>