[mythtv-users] Custom Priority question

[David Engel]

On Mon, Sep 16, 2013 at 07:26:01PM +0200, Jan Ceuleers wrote:
> On 09/16/2013 04:39 PM, David Engel wrote:
> >> Trouble is that when my duration-based rules trigger the new rule does
> >> not seem to be. Is that right: does the scheduler stop looking at the
> >> list of custom priority rules once it finds one that matches?
> > 
> > No, all custom priorities that match are applied.
> > 
> >> If so, how can I change the order of existing custom priority rules?
> > 
> > What is the SQL for your custom priorites?
> 
> Thanks for your reply David.
> 
> My duration-based rules (several of them) are mutually-exclusive
> variations of
> 
> program.endtime-program.starttime<3000
> 
> whereas the one that reduces the priority of early-morning showings on
> the BBC is
> 
> 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.

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.

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

David
-- 
David Engel
david at istwok.net