How to trigger only a particular rule from Detective Rules JOB

[yogesh]

I have two detective user updated rules that I want to run by using the above JOB (DETECTIVEPROVISIONINGRULESJOB)

But I am unable to find the documentation regarding the HQL query parameter, how can I limit the job to only evaluate the said two rules and not evaluate other detective rules in the system?

[rushikeshvartak · Accepted solution]

it uses hanarule table 

sample query : hr.name in ('Transfer Owner')

2022-08-31 14:10:09,056 [quartzScheduler_Worker-2] DEBUG changeaction.UserChangeActionService - evaluateHierarchy-true
2022-08-31 14:10:09,056 [quartzScheduler_Worker-2] DEBUG changeaction.UserChangeActionService - Detective advanced query is true.
2022-08-31 14:10:09,056 [quartzScheduler_Worker-2] DEBUG changeaction.UserChangeActionService - advquery hql = Select hr from HanaRule hr where hr.status = 0 and hr.type = 1 and hr.name in ('Transfer Owner')