[mythtv-users] tricky record rule?

[Stephen Worthington]

On Fri, 13 Nov 2020 16:27:44 -0500, you wrote:

>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

Yes, I now have 82 record.type=5 (power search) recording rules - I
find them very useful.