When a query is performed the response is a dataset which contains a dictionary. The issue is that the dictionary does not have the proper type casting for the attributes (they are just any types). This means that anytime a comparison has to be done, or a wherecontains is used we must first convert the result of the dataset into a proper data type.
Side note, can we just make wherecontains perform basic type casting.
Discussion posts and replies are publicly visible
Joshua F said:Side note, can we just make wherecontains perform basic type casting.
+1 to that!
I agree. When passing values, Appian does a great job in automatic type casting. With comparisons, it does almost nothing. Annoying!
BTW, did you know that if() is pretty flexible. null, 0, 1, 42, -21, "true", "false", true, false, "yes", "no" - you can throw almost anything at it.