Not able to retrieve data from DB

Hi All,

I am running below query to get the data from a table which has 1000+ rows . But it gives me error "Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data." .

When i query DB it doesn't take more than 20 ms . Any help on what can be done?

a!queryEntity(
entity: cons!XYZ,
query: a!query(
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "helpId",
operator: "=",
value: 2
)
},
ignoreFiltersWithEmptyValues: true
),
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: -1
)
),
fetchTotalCount: true
).data

Thanks in advance

Parents
  • Hi Anu,

    Batch size in appian helps in retrieving the large data sets in an efficient way whilst showing the count of whole data set.

    Example: When batch size is set to -1, the effective batch size is unlimited. There is no preliminary count query when batch size is unlimited, (and hence the reduced latency, i.e. it's faster).

    Thanks,

    ravalik

Reply
  • Hi Anu,

    Batch size in appian helps in retrieving the large data sets in an efficient way whilst showing the count of whole data set.

    Example: When batch size is set to -1, the effective batch size is unlimited. There is no preliminary count query when batch size is unlimited, (and hence the reduced latency, i.e. it's faster).

    Thanks,

    ravalik

Children
No Data

 Discussion posts and replies are publicly visible