Instellars Global Consulting
Last activity: 30 Jan 2019 4:32 EST
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.