Question
CIBC
CA
Last activity: 1 Jun 2017 11:56 EDT
obj-browse running to error when using "integer property Is Equal intege param number" as the select condition...
Hi, I got error message when I used obj-browse work objects using " .page.property Is Equal param.number". all .page.property and param.number are integer and .page.property has been exposed.
- There was a problem getting a list: code: 0 SQLState: 42883 Message: ERROR: operator does not exist: numeric = character varying
- Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
- Position: 162
Same condition is used for report, it works fine.
any suggestion? thanks in advance.
***Updated by Moderator: Marissa to update categories***
Cognizant Technology Solution
US
CIBC
CA
I did define both of them as integer. don't know why system always treat the right side as character. even I put the number directly into the right side of equation, it still complain. this is why I'm lost...
Cognizant Technology Solution
US
You may try to use @toInt function from String library in the right side. It might work.So, @toInt(param.number)
CIBC
CA
no luck. same complain.
Cognizant Technology Solution
US
I see. Can you discard the activity and try again? One more thing, on the left side of the condition, the property you are using is exposed ? If not, then also the condition will not work. Although in that case error message will be different but error messages sometimes get messed up. Can you try with an exposed property? I just did a POC, even if I am giving one text and one integer parameter, then also I am able to save it.
There is a type mismatch. I think the properties you are using for the criteria are not of same type. One is of type text and the other one is of type integer. Most probably your parameter is of type text because that is the default type assigned to a parameter. Change it to integer. The Is Equal does not work for Operands with different type.