[mythtv-users] Channel Groups and custom recording rules

[Michael T. Dean]

On 01/21/2013 06:41 PM, Greg Oliver wrote:
> On Mon, Jan 21, 2013 at 12:44 PM, Michael T. Dean wrote:
>> On 01/20/2013 11:33 PM, Greg Oliver wrote:
>>> A couple of months ago (or more), KTVT switched frequencies here.  It
>>> made me mad, so I went and changed all of my rules to anytime/channel.
>>>
>>> Well, I am trying to create a custom rule to allow me to only record
>>> the shows on certain channels (in channel groups) and narrow it down
>>> that way.  It seems the custom recordin rule only allows access to the
>>> program and channel tables though:
>>>
>>> Error preparing query: SELECT NULL FROM (program,channel)
>>> program.chanid = (SELECT channelgroups.chanid where channelgroups.id =
>>> '2') WHERE
>>> program.title = 'Saturday Night Live'
>>>
>>> So, before I go hacking around - is there a better way for me to do
>>> this.  I do not want "first runs only", and I do not want to record
>>> the VH1 versions of SNL either..
>>>
>>> Ideally I will add it to the UI so I can select the channel group when
>>> I create the recording, etc etc.
>>>
>>> Other people doing this successfully in other ways?
>> Use mythfrontend--not MythWeb--to create your Custom/Power Recording Rules.
>> When in the mythfrontend Custom/Power Recording Rule editor, you'll see an
>> "example clause" button that starts out with, "Match an exact title."  If
>> you press this button, it adds the clause to the rule.  If you use
>> LEFT/RIGHT, you can scroll through other examples--including, "Only channels
>> from the Favorites group."  Once you see that, SELECT the button, and then
>> edit the SQL in the text area where you create the rule to contain the
>> desired Channel Group name.
>>
>> Note that there are a /lot/ of very interesting example clauses shown in the
>> editor, so you should always start there when creating new Custom/Power
>> Recording Rules.
>>
>> Mike
> Hmmm - I was using my frontend, but I do not remember the entry to use
> the favorite channel group.  Maybe I'll try a different theme and see
> if it changes.  I did dig through the wiki some more and found some
> examples using external tables, so I was going to try that.  I do
> remember seeing the "Additional Tables" entry in the frontend, but I
> could never guess what needed to be there and get it to work.  After
> the wiki, I think I might have some idea.
>
> Thanks!

It's there, and it's not theme dependent.  Just scroll through them--now 
that you know what you're looking for, it should be easier to find.  
(Though it's possible that the theme you've chosen doesn't have enough 
room to show enough words on the button for you to see, for example, 
"Favorites group"--but at least now you know to look for "Only channels...")

Mike