Hi,
We've a requirement where we are using a form to register user. The form has few fields and one of them is say "isMailboxRequired" which is a checkbox. The approval of the request depends on "isMailboxRequired". If it is true, it will be a two-step approval process, else if the value is false it is a one-step approval process.
I found that the form data is stored in 'PV_CHANGE_REQUEST' in the column FORM_DATA against the Change_request_Id (I'm assuming) , but is in xml format. (the datatype of the column is CLOB) My initial plan was to add a 'SQL select' node in the approval workflow and check the value, but I'm not sure how to parse the xml to retrieve that particular field and check the value.
Does anyone know how to achieve this?
Is there there a simpler way to get the data and compare?
You should have the form variables available in the workflow.
The prefix for them is PublicData_
Following the PublicData prefix, you will have the Workflow Variable Prefix as configured in the form and then the variable name.
During workflow runtime, you will be able to see them (screenshot below)
Example on how to refer to those variables in the workflow: ${PublicData_Create_New_AD_Account_firstname}