cancel
Showing results for 
Search instead for 
Did you mean: 

Dataset in Policy

sandeepverma
New Contributor II
New Contributor II

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.

sandeepverma_0-1666868900008.png

 

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

 

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

You can use like below

rushikeshvartak_0-1666882799908.png

 

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

sandeepverma
New Contributor II
New Contributor II

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.

sandeepverma_0-1666932521507.png

suppose the below screenshot is our created DataSet.

sandeepverma_1-1666932931684.png

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,

 

It’s not feasible