[mythtv-users] Fall cable reruns and mythTV
kkuphal at gmail.com
Wed Sep 3 16:54:39 UTC 2008
On Wed, Sep 3, 2008 at 11:33 AM, David Linville
<dlinvill at networksdown.com>wrote:
> On Tue, Sep 2, 2008 at 8:07 PM, <mons37318 at mypacks.net> wrote:
>> Do we have a way to tell myth to list (but not record, as in the new pilot
>> search) pilot episodes of old series that we a. didn't watch at the time
>> they were new or b. never were aware of to begin with?
>> the *new* pilot search is as follows
>> program.previouslyshown = 0
>> AND program.first > 0
>> AND program.programid LIKE 'EP%0001'
>> AND DAYOFYEAR(program.originalairdate) =
>> i'm guessing that the program.previously shown (at least, and possibly
>> something else - my SQL isn't that great) will disinclude Old pilots. at
>> least if it = 0
> I just tried
> program.first > 0
> AND program.programid LIKE 'EP%0001'
> AND DAYOFYEAR(program.originalairdate) < DAYOFYEAR(program.starttime)
> which seems to do exactly what you want but I get 5-6 'old pilots' per day
> so for me it really would only work as a search and not a record rule.
The guide information may not contain the program.programid in the format
you specified. Try removing that line
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users