[mythtv-users] Power Search - People search - anyone?

David Engel david at istwok.net
Tue Nov 13 15:37:05 UTC 2012


Please don't top post.

On Tue, Nov 13, 2012 at 09:52:41AM +0100, Ole Nissen wrote:
> 2012/11/12 David Engel <david at istwok.net>
> 
> > On Mon, Nov 12, 2012 at 08:11:47AM +0100, Ole Nissen wrote:
> > > I want to be able to do a power search and record all movies when one or
> > > more actors are on the role list. I have followed the guide on the wiki:
> > > http://www.mythtv.org/wiki/Custom_Recording: People Search replacement:
> > An
> > > Advanced Custom Recording Example
> > >
> > > In mythweb->Custom->Power Search->Additional tables, I put the string:
> > >  "JOIN credits AS c ON c.chanid=program.chanid AND
> > > c.starttime=program.starttime JOIN people AS p ON p.person=c.person"
> > >
> > > And in the search part:
> > > "p.name = 'Bruce Willis'
> > >
> > > When I submit this, an error is thrown, caused by an invalid "," that is
> > > put before the Join statement. This has to be an error in the mythweb
> > > script. So I tried to do the same from the frontend. Here it is possible
> > to
> > > put in the join statement, but it still doesn't find any recordings.
> > >
> > > Does anyone have a working rule to spare?
> >
> > Ues mythfrontend.  Apparently, mythweb insists on adding the leading
> > ',' which is needed for some queries.
> 
> Ok, so I should add the rule through the frontend. Can anyone confirm that
> the above works from the frontend. I couldn't get it to wok.

Yes and yes.  I tested it before I posted.

David
-- 
David Engel
david at istwok.net


More information about the mythtv-users mailing list