[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