Hi Team - Need to make use of the Fulfillment date and Revoke date on the global form, to make some decisions. How to access these field values inside the approval workflow?
If you create a sql select node in the workflowand right-click on query part you can find useful variables. Unfortunately not all available variables are listed but there are built-in variables for fulfillment date ${access_request_fulfilldate} and revocation date ${jobUserData_PublicData_Application_Form_mod_RevocationDate}
Possible that the second one is there only if you enabled revocation date in submission field settings but you can try it in your environment.
Hi,
If you create a sql select node in the workflowand right-click on query part you can find useful variables. Unfortunately not all available variables are listed but there are built-in variables for fulfillment date ${access_request_fulfilldate} and revocation date ${jobUserData_PublicData_Application_Form_mod_RevocationDate}
Possible that the second one is there only if you enabled revocation date in submission field settings but you can try it in your environment.
Zoltan