Not able to browse records based on a case insensitive keyword in an exposed column
I have to browse the records from the table based on flag using "Obj-Browse" method in an activity as in the below screenshot. if the flag is true, then look for the word "completed" in the pylabel column.
Here, "pylabel" is an exposed column in the table. As "completed" can be written in any case, I've used uppercase on LHS and "COMPLETED" in RHS but it's throwing the below error. To be precise, the RHS has the expression " (Param.IsCompleted==true)?"COMPLETED":"" ".
If the expression is evaluated to false, the criteria should be ignored which I guess will work as I am using "contains" as the comparator.
Can somebody help me with this? Thanks in advance.
Are you suggesting to use the condition as the pre-condition to the step? If so, how do you achieve it as I've to compare the result of the condition to the "pyLabel" column? Can you elaborate on your comment? Thanks in advance.