In workflow I would like to use requested application's database ID. For application's name I can use ${access_request_cri_app_name}. On this model I tried to use ${access_request_cri_app_id} but did not return any value. Any suggestion?
In workflow I would like to use requested application's database ID. For application's name I can use ${access_request_cri_app_name}. On this model I tried to use ${access_request_cri_app_id} but did not return any value. Any suggestion?
I believe your approach would be to add a 'SQL SELECT' node to your workflow to gather this into a variable.
i.e.
SELECT PVA.ID as APPLICATION_ID FROM PV_APPLICATION PVA
WHERE PVA.NAME = '${access_request_cri_app_name}'I came to this workaround as well. I think there are also some not documented built-in variables which are more easy to use but this solution will do.
I believe your approach would be to add a 'SQL SELECT' node to your workflow to gather this into a variable.
i.e.