[mythtv-users] Channel Groups and custom recording rules

Greg Oliver oliver.greg at gmail.com
Tue Jan 22 02:47:14 UTC 2013


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

That worked great - I do not know how I missed the Favorite Group and
more importantly Video Source.  I only have 2 video sources, and I
will usually want 1 or the other, so that fit the bill nicely.

Thanks again


More information about the mythtv-users mailing list