[mythtv-users] tricky record rule?

[Stephen Worthington]

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.