I am creating a request workflow to handle user access reviews. I would like to make some decisions in workflow based on review name. I tried to use ${reviewName} in a sql select node (select ${reviewName} as review_name from dual) but when running the review the generated CR has a workflow variable with the following value:
review_name: ?no review id found?
I am on 7.2.0 (no patch). What do I do wrong? How can I get the review name?
I don't see ${reviewName} variable being available in a workflow. How did you come up with this?
Try this workaround.
select pr.NAME as review_name from pv_change_request pcr
join pv_review pr on pcr.SOURCE_OBJECT = pr.id
where pcr.ID = ${access_request_requestID} and pcr.source_type like '%Review'
In an older community article (000032956 - How to add images to RSA Via Lifecycle and Governance email templates ) I found notification emails can use {$reviewName} variable. This is something similar so I thought it can be used in other wf elements as well. Your workaround does the job so I am ok with it.
By the way is there a complete list of builtin variables which can be used in workflow nodes?
If you simply right click inside the editor or any SQL Node (and many other nodes/text areas in the workflows), you will see a context menu with all available built-in and custom workflow variables that are available in that workflow.
I don't see ${reviewName} variable being available in a workflow. How did you come up with this?
Try this workaround.
select pr.NAME as review_name from pv_change_request pcr
join pv_review pr on pcr.SOURCE_OBJECT = pr.id
where pcr.ID = ${access_request_requestID} and pcr.source_type like '%Review'