[mythtv-users] SQL for Myth

Edward M. Brown edwardb at gmail.com
Thu Apr 13 20:37:34 UTC 2006


That worked, thanks for your help.

Ed

On 4/13/06, Kevin Kuphal <kuphal at dls.net> wrote:
> Edward M. Brown wrote:
> > I have a SQL command to find all shows that match credits of people I have entered into the people search list. It works fine if you run it in MySQL.
> >
> > select people.name, program.title, program.subtitle, program.starttime from ((keyword inner join people on people.name = keyword.phrase) inner join credits on credits.person = people.person) inner join program on program.chanid = credits.chanid and program.starttime = credits.starttime;
> >
> > What I would like to be able to do is adapt this somehow to create a pick list of programs based on people in my list.
> >
> > I played around with trying to get this to work with Custom Record, but didn't have any success. Also the Custom Record capability automatically records programs, I'm trying to create a pick list.
> >
> > Any suggestions, ideas would be appreciated
> >
> >
> You should be able to go into the Search Lists and create a keyword
> search for the person you want.  I've done this for "Robin Williams".
>
> You can then view this query in the frontend whenever you want.  You can
> also create a recording rule from this.  I would suggest doing this, but
> setting the rule to be inactive.  This will cause all showings to show
> up in the Upcoming Recordings screen in white where you can then add
> individual overrides for any showing you want to record.
>
> Kevin
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>


--
Edward M. Brown


More information about the mythtv-users mailing list