[mythtv-users] tricky record rule?

[James Abernathy]

On Fri, Nov 13, 2020 at 10:24 AM Stephen Worthington <
stephen_agent at jsw.gen.nz> wrote:

> On Fri, 13 Nov 2020 09:17:27 -0500, you wrote:
>
> >I need help with  a record rule. I have a Rule to record "College
> >Football". This gets all college football games regardless of network.
> The
> >problem is that Channel 22_2   Stadium shows reruns of a lot of football
> >games in 480i, which I do NOT want to record.
> >
> >I only want the new games on 5_1, 11_1, 17_1 and 50_1.  So I could either
> >list just these 4 channels or somehow list 22_2 as a DO NOT record.
> >
> >How would I do this?
>
> You can do it with a Power Search rule.  Manage Recordings > Schedule
> Recordings > Custom Record.  You have to write some SQL to tell the
> rule what to match, so something like this should work:
>
> program.title='College Football' and program.chanid<>ID
>
> where ID is the chanid corresponding to the 22_2 channel.  To find
> that chanid, you need to do an SQL query on the channel table,
> something like this:
>
> sudo mysql mythconverg
> select chanid,channum,name,callsign from channel where name='22_2';
> exit
>
> Make sure you delete your old rule after you get the new one working.
>
> Thanks, a lot! This really works.  I wish they had invented mysql back
when I was a database administrator.  Back then it was MRI System 2000
running on a CDC 6000 and I used punch cards to submit queries. :-)

Jim A
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20201113/0b6251b8/attachment.htm>