[mythtv-users] tricky record rule?

Michael T. Dean mtdean at thirdcontact.com
Wed Nov 18 12:32:09 UTC 2020

On 11/14/2020 10:19 AM, Simon Hobson wrote:
> James Abernathy  wrote:
>> 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. :-)
> I'm just a young whipper-snapper and only used GUIs and SQL for the last few decades :D
> I tend to use channel.callsign as in these examples which might give you some ideas :
> ((program.title like 'Cricket%' and callsign = 'Channel 5')
> or
> (program.title = 'ICC World Cup Cricket' and callsign = 'Channel 4')
> or
> (program.title = 'Test Cricket')
> or
> (program.title like 'One-Day International Cricket%')
> or
> (program.title like '%International T20 Cricket%'))
> (program.title like 'CSI%' and not program.title like 'CSI: NY%')
> AND (channel.callsign like 'FIVE%' or channel.callsign like 'Channel 5%')
> (    program.title = 'Have I Got News for You'
>    OR program.title = 'Have I Got a Bit More News for You'
>    OR program.title = 'Have I Got Old news For You'
>    OR program.title = 'Have I Got Sport for You' )
> AND channel.callsign like 'BBC %'

In the custom recording rule editor screen are "example clauses" that 
show approaches you can use.  Included are:

Match an exact title
program.title = 'College Football'

Match words in the title
program.title LIKE '%football%'

and, more importantly,

Only on a specific station
channel.callsign = 'ESPN'

Exclude one station
channel.callsign != 'Stadium'

Match related callsigns
channel.callsign LIKE 'ESPN%' AND cg.grpid = cgn.grpid AND 
program.chanid = cg.chanid

Only channels from the Favorites group
cgn.name = 'Football'
(where you've specified the extra tables: ", channelgroup cg, 
channelgroupnames cgn" )

and similar.  If using the "Only channels from the Favorites group" 
clause, definitely select it in the editor, then edit "Favorites" to say 
"Football" or whatever you've called the channel group that includes 
only the desired channels--doing so fills in the extra tables part for you.

The "Favorites" group approach is very nice in that you can edit the 
channels you're allowing--add new ones when appropriate or remove 
channels you want to exclude--without editing the rule, even if you 
completely change providers/lineups.


More information about the mythtv-users mailing list