Query to identify all the user update rule triggering a given technical rule

[WeAreVoid]

let say we have one sample technical rule "Test_Assign_finance_global" from which er are providing the access finanace_global group.

I want to run query that will produce the name of user update rules those are triggering this given user technical rule.

[PremMahadikar]

Hi @WeAreVoid ,

Please try the below query:

select 
	ha.name, 
	case 
		when ha.STATUS=1 then 'True' 
		when ha.status=0 then 'False' 
	else ha.status end as 'Rule status' 
from 
	hanarule ha, 
	hanaruleattribute hat 
where 
	ha.HANARULEKEY=hat.HANARULE and 
	ha.type in (3,2) and 
	hat.OBJECTVALUE in (select ha1.HANARULEKEY from hanarule ha1 where ha1.type=1)

Note:

1. The query was build using my sample data. You can refer the query to add or filter columns based on the data you have
2. Type: 1 is used for Technical Rule, and Type: 2,3 is used for User Update Rule

If this helps your question, please consider selecting Accept As Solution and hit Kudos

[rushikeshvartak]

You can check this information in Execution Trail