Find Rules by Checklist Group or Item

🔎 How can I find which rule(s) reference a particular checklist group?

Hopefully someone put the group name in the rule name, but if not…read on!

Find Rule by Checklist Group

SELECT *
FROM [rule]
WHERE 1 = 1
    AND [xml].value('(p[k = "group"]/v)[1]', 'varchar(250)') = '<checklist group name>'

Find Rule by Checklist Item

SELECT *
FROM [rule]
WHERE 1 = 1
    AND [xml].value('(p[k = "section"]/v)[1]', 'varchar(250)') = '<checklist guid>'