[mythtv-users] Custom Priority question

[Jan Ceuleers]

On 09/16/2013 09:36 PM, David Engel wrote:
>> program.chanid in (select chanid from channel where lower(callsign) like
>> 'bbc%') and  hour(program.starttime) < 5
> 
> I tried this and it works as expected for me.  Why do you think it
> isn't working?  Note that the secondary priority, which includes the
> custom priority contribution, isn't currently displayed anywhere
> except in debug logging.

Thanks David (and also Mike).

The reason why I don't think it's working is that I'm still seeing
recordings being deferred from early evening (the showing I want) to
middle-of-the-night a couple of days later, although there is no
shortage of tuners at the earlier time.

I just looked at an example, and strangely enough in that case the later
showing is 5 minutes longer than the earlier-one, taking it across the
boundary between two duration-based rules. But the duration-based rules
step up the priority in ones, whereas the middle-of-the-night rule
subtracts 25. So that shouldn't be the reason.

> FYI, program.starttime is in UTC, so even if you're in the UK, this
> might not do exactly what you want at least part of the year.

Thanks, yes I had thought of this. I'll refine this later when I
actually get it to work.

> FYI2.  The channel table is already included in the bigger query, so
> you can simplify this to
> 
>   lower(program.callsign) like 'bbc%' and hour(program.starttime) < 5

Good to know. Once I understand this more fully I'll add this to the wiki.

Thanks, Jan