[mythtv-users] tricky record rule?
stephen_agent at jsw.gen.nz
Sat Nov 14 02:27:28 UTC 2020
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.
>> >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';
>> 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. :-)
Yes, I now have 82 record.type=5 (power search) recording rules - I
find them very useful.
More information about the mythtv-users