[mythtv-users] Question on using logic in recording schedule

[David Engel]

I fixed your top posting this time.  Please don't do it any more on
the mythtv lists.

On Mon, Jan 17, 2011 at 04:56:29PM -0500, Aaron Klein wrote:
> On Mon, Jan 17, 2011 at 4:40 PM, Kevin Kuphal <kkuphal at gmail.com> wrote:
> > On Mon, Jan 17, 2011 at 3:28 PM, Aaron Klein <klein.aaron at gmail.com>wrote:
> >> I enjoy the various racing series's under the main title Nascar Racing.
> >> There are a few regular recordings that deal with qualifying or other type
> >> shows that are also listed normally under the main title of Nascar Racing.
> >> Is there a way to do logic in the recording schedule so it records shows
> >> that being with Nascar Racing but to exclude those that the word
> >> "qualifying" or some other phrase within the show name?
> >
> > You'd have to do it with a custom recording rule, but with some massaging
> > of one of the examples and a little SQL knowhow, it shouldn't be hard to
> > make one.  If you post an example of title/subtitle/description from one of
> > the listings, I'm sure someone here can help generate the query also.
> 
> Title and subtitle of a desired recording
> 
> NASCAR Racing:
> Toyota All-Star Showdown: Irwindale
> 
> The undesirable recording
> 
> NASCAR Racing: Toyota All-Star Showdown, Qualifying
> 
> The only consistancy is the main title of NASCAR Racing and the word
> Qualifying on the desirable recordings.  Other aspects of the subtitle will
> change depending on the event.  The shows will air on different networks
> aswell.  There is usually no description on the listings.

Here is the SQL I use to record the Sprint Cup and Nationwide Series
races and exclude the other series and qualifying and practice.

program.title = 'NASCAR Racing' AND (program.subtitle LIKE 'Sprint Cup:%' OR program.subtitle LIKE 'Nationwide Series:%') AND program.subtitle NOT LIKE '%Qualifying%' AND program.subtitle NOT LIKE '%Practice%'

David
-- 
David Engel
david at istwok.net