1 of 1 people found this helpful
Figured it out. I was able to set a Text process variable (Amount2) to a Decimal process variable (Amount1) using the Output map in a Build Input Set step. I can use the decimal variable for conditional numerical evaluation successfully and use the text variable to pass to the Work Order using a text WO Type field.
Can you help with the workflow you designed for this. We have similar type of use-case.
Sure thing - let me know if there are any specifics that you would like me to elaborate on...
I created the questionnaire with a field "Amount", type = Decimal, which mapped to a Process Variable, also called "Amount".
I created a workflow with an exclusion gate and 2 conditional branches; (1) checks if [Amount >= $100,000.00] AND [Amount < $500,000.00], and (2) checks if [Amount >= $500,000.00]. The third branch is the 'default' (does not match any other conditions) and catches everything where [Amount <$100,000.00].
For each of these conditional branches I invoke the "Call Activity" element, set the Called Process to "Request Approval" and supply the corresponding approval process information. I created custom approval processes for this particular task, but any existing approval process in AP:Administration will work.
Once the approvals were obtained, the flow continues to create a Work Order record (Create Remedy Work Order element). Before the Create Remedy Work Order step I include a Build Input Set step to set the parameters that I will pass to the Work Order. Since I was using most of the WO Type fields (flex fields, the ones they give you play with when building old SR's in SRM or now with DWP-A) it required multiple Build Input Set steps (the element is limited to 10(?) fields).
The input mapping within the step is where the parameter information is defined, but the output mapping goes unused unless you decide to use it (which I did!!) I created an output mapping to include a new process variable (Amount2), type = text, and set Amount2 to Amount (the decimal variable). I could then use Amount2 in a subsequent Build Input Set set as the variable set for a given WO Type Field parameter (since it was later in the field list I did not need any additional Build Input Set elements, however if it were earlier on - like needed for the first Build Input Set instance - I would just include an additional Build Input Set element and only set the Output Mapping information to include the necessary variables - you could probably also use many other elements' output mappings for this as long as they come before you need to use the variable).
What this accomplished was effectively casting my Decimal value to a Text value, contained in 2 separate process variables - Amount and Amount2, respectively. I was then able to work with Amount for any numerical evaluation operations correctly and still pass this information to the Work Order as a text field, Amount2.
I hope this helps!
This absolutely helps. Thanks for all the details.