Skip to main content

Find Rules Assigning Inactive Bins

Get this query from our Analysis suitcase: 4e5a7b48-104c-481d-8857-b5ce1148e9e0:rwf

Visually, a rule that assigns an inactive Bin is confusing, as it will say "Leave Current" instead of whatever Bin was originally in the rule but has since been inactivated.

image.png

You can query for such rules and disable them. Start a Configurable Joins query on the CJ > Related > Rules base, then add a Custom SQL filter:

try_cast([xml].value('(p[k="bin"]/v)[1]', 'varchar(36)') as uniqueidentifier)
in (
select [id]
from [lookup.bin]
where [active] = 0
)