[mythtv-users] SQL Query Help

Craig Huff huffcslists at gmail.com
Thu Jan 18 17:08:37 UTC 2018


On Thu, Jan 18, 2018 at 8:46 AM, Michael T. Dean <mtdean at thirdcontact.com>
wrote:

> You could just create another Custom Recording Rule that records all
> episodes of any titles that exist in the Premieres recording group...
> Something like
>
> program.title in (SELECT DISTINCT(title) FROM recorded WHERE recgroup =
> 'Premieres')
>
> (There may well be much more efficient SQL to allow this...  Some kind of
> JOIN-based approach that avoids the subquery or ...  I'll let others who
> are better at SQL come up with improvements as desired.)
>
> and, if you had that recording rule record to a the "Premieres" recording
> group, then when you see multiple episodes of a series in "Premieres", you
> can go and create a new recording rule for that series.  Then, just change
> the recording group of the already-recorded episodes to that used for the
> new series-specific rule (you can do this by putting all the episodes of
> the series in a playlist then using Playlist Options to change the
> recording group of all of them at once).
>
> This has the benefit that it's self-maintaining until you get around to
> looking at the episodes, so you don't have a "have to check at least every
> 2 weeks or else I miss some episodes" problem.
>
> Mike
>

Thanks, Mike!  I like that!

--
Craig.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180118/eb4607f9/attachment.html>


More information about the mythtv-users mailing list