How to use Datasets in user update rule

[Srinivas_N]

Hi,

We have a requirement to use datasets value in user update rules and Im not able to find the document regarding it. can someone help me on how to use datasets in user update rules.
I tried to create one rule with trigger option as when user is updated from UI and selected advanced query, below is the query:
select attribute1 from dataset_values where datasetname = 'countrycode'.
but the rule is not triggered

Thanks
Srinivas N

[rushikeshvartak]

a.email IS NOT NULL AND (substring_index(a.email,'@',-1) in (SELECT attribute1 from Dataset_Values where datasetname = 'dataset'))

Refer https://forums.saviynt.com/t5/identity-governance/dataset-in-technical-rules-amp-user-update-rules/m...