[mythtv-users] SQL help with custom priority rule using recgroups table

[Will]

On 7 November 2017 at 12:13, Joey Morris <rjmorris.list at zoho.com> wrote:
> This is a shot in the dark, because I haven't really used this feature of
> MythTV and haven't tested this, but maybe you could change your rule to:
>
>   channel.callsign LIKE '% HD' AND recgroups.recgroup = 'Childrens Programmes'
>   AND record.recgroupid = recgroups.recgroupid
>
> and add recgroups to the Additional Tables field:
>
>   , recgroups
>
> Have you looked at https://www.mythtv.org/wiki/Custom_Recording? It has several
> custom recording rules that may give you other ideas on how to approach this,
> including examples of joining additional tables. Also, the very end shows how
> MythTV structures the MySQL query, which you might be able to use to test/debug
> your rule at the MySQL command line.

I appreciate the shot in the dark. The 'Custom Priority' feature is
slightly different in that I can't see a way to add additional tables,
but I'll give that a go anyway and let you know!

Will