We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Dataset in Workflow

sab2
Regular Contributor
Regular Contributor

Hi,
Does anyone know the syntax for referencing a dataset in a workflow (if else block)? I tried some searching and did not see many references.
We have a dataset with attribute1 and attribute2. For example, attribute 1 is 'Location name' and attribute2 is 'Blue' or '123'

In our workflow we want to have logic that says if customproperty3 (which the value is listed from attribute1 in dataset) has a value from attribute2 as '123' from dataset, set to true, else false.

Is this achievable? 

Thank you

1 REPLY 1

adriencosson
Regular Contributor III
Regular Contributor III

Hello,

As datasets are not exposed in workflows, I would suggest you to add the dataset values as dynamic attributes during your request, so you can use them later in the workflow.

Below is a sample SQL query to be used in a dynamic attribute.

SELECT distinct attribute1 as ID FROM dataset_values WHERE datasetname='myDatasetName'

Then refer to this document on how to get dynamic attributes in workflow :

https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter12-Workflows/Workflow-Compon... 

Hope this helps !

Regards,
Adrien COSSON