[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