Skip to main content

Find Rules Assigning Bin

Finding which rule is assigning a bin requires knowing the bin's GUID. You can query this from the Configurable Joins > System > Reader Bin base.

This works for both Reader and Workflow bins and rules.

SELECT *
FROM [rule]
WHERE 1 = 1
	AND [xml].value('(p[k="bin"]/v)[1]', 'varchar(40)') = 'c2ac7cf1-4d27-4f21-9ff6-326bad1fa360'
	AND [active] = 1