query entity not retrieving data correctly

Certified Associate Developer

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.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data