Can we identify the task which got triggered for a particular user update rule

[Debankita]

Hi Team,

Can anyone please help me with the valid SQL query which will help me to fetch the tasks which got triggered due to a particular user update rule?

[nimitdave]

check arstasks table source,assignedfromrule column for the rule key through which this task go created.source column should have value as zero day.

[SB · Accepted solution]

Below is the query you can try

select TASKKEY,userkey from arstasks where ASSIGNEDFROMRULE in (select objectvalue from hanaruleattribute where (objectvalue !='') and HANARULE in (select hanarulekey from hanarule where type='2' and name = 'User_update_rule_Name'))