In need to group a column and get count of other column data on output of a query, getting below error

@madhubindug Not sure if the above solution has helped you or not, just now I have faced the same issue and resolved the value by converting the values to a plain array using tointeger(). The actual problem here is, the data returned by a!queryEntity() which is in the format of datasubset of dictionaries returns you an array of arrays when you try to access the fields inside the data. (for instance, local!datasubsetDeficiency.data.requestId in your case.) As IN operator expects a plain array, the queryFilter fails and hence the expression fails on the whole. So we should type cast the value of the queryFilter, i.e. we should convert the value into a plain array using functions such as tointeger() and thereafter we should provide the same to the queryFilter.

@madhubindug Not sure if the above solution has helped you or not, just now I have faced the same issue and resolved the value by converting the values to a plain array using tointeger(). The actual problem here is, the data returned by a!queryEntity() which is in the format of datasubset of dictionaries returns you an array of arrays when you try to access the fields inside the data. (for instance, local!datasubsetDeficiency.data.requestId in your case.) As IN operator expects a plain array, the queryFilter fails and hence the expression fails on the whole. So we should type cast the value of the queryFilter, i.e. we should convert the value into a plain array using functions such as tointeger() and thereafter we should provide the same to the queryFilter.