Question
Instellars Global Consulting
SG
Last activity: 30 Jan 2019 4:32 EST
Not able to browse records based on a case insensitive keyword in an exposed column
Hi All,
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.
Regards,
Giridhar Metikal
Areteans
IN
Hi,
This is a wrong approach. You need to use the flag in the step when match condition.
Thanks
Kamalesh
Instellars Global Consulting
SG
Hi KAMALESH_TECH,
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.
Accepted Solution
Areteans
AU
Hi Giridhar,
This you cannot do using 'obj-browse method.The approach you are following will ultimately be case sensative.
as solution:
You need to create a 'Connect SQL' rule and wite your query in it, to fetch the list of records from 'Data-Rule-Summary'.
Then call this 'Connect SQL' rule using 'RDB-List' activity method.
This way you can populate the 'RSVList' page.
Note:
While calling RDB-List method,It needs a parameter named 'Access',
You also need to identify 'Access' to DB, whether it is 'oracle' or 'MySql',and this you should pass as value in 'Access' parameter to RDB-List method.