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.
Mike
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users http://wiki.mythtv.org/Mailing_List_etiquette MythTV Forums:
https://forum.mythtv.org