[mythtv-users] Channel Groups and custom recording rules

[Greg Oliver]

On Mon, Jan 21, 2013 at 12:44 PM, Michael T. Dean
<mtdean at thirdcontact.com> 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!