03/16/2023 11:37 AM
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?
Solved! Go to Solution.
03/16/2023 02:16 PM
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 :
Hope this helps !