[mythtv-users] Help With Custom Record Rule Syntax

[Michael T. Dean]

On 03/08/2008 05:11 PM, Drew Tomlinson wrote:
> Michael T. Dean wrote:
>   
>> On 03/08/2008 02:17 PM, Drew Tomlinson wrote:
>>> I am currently using 0.20.2 from Gentoo's portage system.  The system 
>>> status screen shows the Myth version as "0.20.20070821-1".
>>>
>>> Back some time ago, Bruce Markey posted an idea for a custom recording 
>>> rule marked as 'inactive' to alert one to upcoming new shows.  My 
>>> version of the rule is this:
>> ...
>>   
>>     
>>> AND
>>> channel.callsign IN ("KCRA", "KQCA", "KXTV", "KOVR", "KMAX", "KXTL")
>> Your output shows KTXL, not KXTL, though the others from KCRA and KMAX 
>> should show (at least in the direct query).  Note that the only ones 
>> that occur in the future are on KTXL, so...  Note, also, you're not 
>> including KTXLDT or KCRADT or KMAXDT.
> Oh, whoops!  I don't know how many times I "verified" that the callsigns 
> were correct.  Thanks for catching my error.  This was driving me nuts!
>   

Sometimes it just takes a fresh pair of eyes.

>> Unrelated to the problem you're seeing, but--since you are most likely 
>> using Schedules Direct--why aren't you using the example "first 
>> episodes" clause?
> I am using Schedules Direct however I added this rule several years ago 
> before SD existed.  I was probably still using 0.17.  At that time the 
> example didn't exist in mythfrontend and the one discussed on this list 
> was more like mine as I recall.  I'm no SQL expert but I suspect the new 
> example is more efficient.  I will check it out.
And, probably more likely to work well with SD data.  I'd recommend 
using the one from trunk/0.21-fixes (the shorter of the two).  It's 
working great for me.  You could always just wait until you upgrade to 
0.21 (as soon as the packages are available for your distro) if you 
don't want to type it in.

Mike