Decision Table not returning correct Value using expressions
Hi ,
we have a requirement to fetch some values through excel Upload.
example :
In excel we retrieve below data
| Column 1 | Column 2 |
|---|---|
| SCRS1E31 | ABC |
| D5 | XYZ |
Based on column 1 we need to set some other fields, column 1 contains a code and based on that code we need to set some values.
| Column 1 | type | start date | end date | Number |
| SCRS1E31 | Screening | 1 | 31 | |
| D5 | Day | 5 |
we have used regular expressions to find this pattern, then used below decision table to find retrun values. but the issue when we test the regular expression, its working find based on the input. but when we use it as expression in a decision table. every time it returning some other value.
Could you please anyone assist on this,
Accepted Solution
Updated: 7 Oct 2022 15:16 EDT
Pegasystems Inc.
IN
Not sure if the reg expression is not working or the column is not appropriately set OR parameter is not being passed. I would suggest you have a similar implementation as below
1) Set a boolean flag (Let's say "TrueFlag") to true on the page where the decision table is executed.
2) Create two when rules one for screening and another for Day
3) Cal the when rule in the row as shown in the image. 
4) Ensure the column uses "TrueFlag" property which has the value true.
Ensure that when rule is working as expected. Let me know if any more details are required.
NOTE: evaluateWhen is an OOTB function
Virtusa Corp.
LK
Thanks for the response. what we have missed is to set the Boolean flag when execute decision table. when we do that, our previous approach too working fine.
Thanks for the quick response.