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?