Dataset in Workflow

[sab2]

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

[adriencosson · Accepted solution]

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 !