[mythtv-users] Conditional custom recording rule

[John P Poet]

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.

John
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20141006/6a056b52/attachment.html>