query entity not retrieving data correctly
Hi Team,
QueryEntity is not fetching data correctly, below is my code:
a!queryEntity(
entity: cons!TEMP_TABLE,
fetchTotalCount: ri!fetchTotalCount,
query: {
a!query(
selection: if(
rule!APN_isEmpty(ri!columns),
{},
a!querySelection(
columns: a!forEach(
ri!columns,
a!queryColumn(field: fv!item)
)
)
),
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "clientId",
operator: "=",
value: ri!clientId
),
a!queryFilter(
field: "requestorName",
operator: "=",
value: ri!requestorName
),
a!queryFilter(
field: "engagementNumber",
operator: "in",
value: ri!engagementNumber
),
},
ignoreFiltersWithEmptyValues: true()
),
paginginfo: if(
rule!APN_isEmpty(ri!pagingInfo),
a!pagingInfo(startIndex: 1, batchSize: - 1),
ri!pagingInfo
)
)
}
).data
In the test output, it is returning the result as infinity symbol for a particular column which is number(integer), shown below:

My table in the backend holds a valid value for the particular column, but somehow the queryentity is unable to fetch it properly.
Any suggestions to fetch the correct value please?
Thanks.
