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.
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
)
No Comments