Hi every one,
I'm having a local variable that store data in a Json format then converted it into a type that Appian accepts:
a!fromJson(local!settings)
and I get this as the result:
Dictionary
I want to get all the settings with value equals a particular ID, but it shows this error: Expression evaluation error at function 'wherecontains' [line 41]: Invalid types, can only act on data of the same type (Number (Integer), Any Type).
index(local!settings, wherecontains(local!currentType.Id,local!settings),"value",null)
I guess the issue is because value is now containing special characters.
Any one having a solution for this?
Thanks a lot in advance for your helps!
Discussion posts and replies are publicly visible
Just wrap the second parameter of whereContains() function in toInteger() and that should work.
index(local!settings, wherecontains(tointeger(local!currentType.Id),tointeger(local!settings)),"value",null)
There are no special characters. wherecontains requires the data types to match. This is what the error message claims.
Thanks Harshit!
Thanks a lot Stefan!
Spambots getting more and more crafty...