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
Just FYI - our new function a!queryRecordType() returns a different type: a record map. The record map gives you the benefits of a map (strongly typed columns, doesn't break if you index a field that doesn't exist) and the overall type is a record data type, so you don't have to do any casting when you need the whole record.