Dataset in Policy

[sandeepverma]

Hi All,

I have created one dataset as per the below name and I want to use this data set in technical rule - object section.

sample code 1: ${if(user.location.equals(dataset_values.attribute1) && dataset_values.datasetname.equals('ADGroups')){dataset_values.attribute2}}

sample code 2:  ${if(user.location.equals(select dataset_values.attribute1 from dataset_values where dataset_values.datasetname  = 'ADGroups' and dataset_values.attribute1 = user.location)){dataset_values.attribute2}}

Both are not working so any anyone please suggest how can we use this data set.

Thank You

[rushikeshvartak]

You can use like below

a.userkey=268117 and a.customproperty64 in (select distinct dataset_values.attribute1 from dataset_values where dataset_values.datasetname = 'City' )

Change Query as per your needs

[ShubhamBabbar]

Hi @rushikeshvartak,

I am trying to use the logic specified by you above but getting the following error:

I am on v23.9

This is my policy:
(##a.customproperty4 isupdated##) and (a.customproperty4 in (select distinct dataset_values.attribute1 from dataset_values where dataset_values.datasetname = 'ISO_COUNTRY_CODE'))

Can you please suggest what might be wrong.

Thanks,
Shubham

[sandeepverma]

Hi Rushikesh Vartak,

Thanks for your reply. 

But I want to put dataset query in Action part to populate the OU groups based on Location.

suppose the below screenshot is our created DataSet.

So whatever user's location I am getting during user import we want to compare that user location with our dataset and populate corresponding securitygroups in object section of Action part of Technical Rule.

Can you we do the same?

Thank you,

[rushikeshvartak]

It’s not feasible 

[Darshanjain]

Hi @sandeepverma 

Its not possible to use those logics in the Action object

Thanks

Darshan

[ShubhamBabbar]

Hi @Darshanjain 

I am trying to use the logic specified by you above but getting the following error:

I am on v23.9

This is my policy:
(##a.customproperty4 isupdated##) and (a.customproperty4 in (select distinct dataset_values.attribute1 from dataset_values where dataset_values.datasetname = 'ISO_COUNTRY_CODE'))

Can you please suggest what might be wrong.