Appian 19.4 Hotfix C
we have a Query entity and have passed in paginginfo as parameter from SAIL for pagination with batchsize of 10.
and have fetchTotalCount :true
but on the result it shows totalCount : 1
Total record count is 33 and paging info is 10. But in Data and identifiers we see 10 items
a!queryEntity( entity: cons!XXX, query: a!query( selection: a!querySelection( columns: { a!queryColumn( field: "X" ), a!queryColumn( field: "X" ), a!queryColumn( field: "X" ), a!queryColumn( field: "X" ), a!queryColumn( field: "X" ), a!queryColumn( field: "X" ), a!queryColumn( field: "X" ), a!queryColumn( field: "X" ) } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "X", operator: "=", value: ri!X, applyWhen: if(rule!APN_isBlank(ri!X), false, true ) ), a!queryFilter( field: "X", operator: "=", value: ri!X, applyWhen: if(rule!APN_isBlank(ri!X), false, true ) ), a!queryFilter( field: "X", operator: "=", value: ri!X, applyWhen: if(rule!APN_isBlank(ri!X), false, true ) ) }, ignoreFiltersWithEmptyValues: false ), pagingInfo:ri!pagingInfo ), fetchTotalCount: true )
Discussion posts and replies are publicly visible
Can you expand the "identifiers"? One area to check is that totalcount can be different than the number of results if the identifiers overlap - essentially the totalcount is the number of unique identifiers.
Thanks Chris that was the problem. Now i had added a unique row on the VW using Row_number to get a unique column. And then added it to CDT and Qe and now it works.
Great! :)
For some additional information on what Chris explained, please also see this KB which explains the issue: community.appian.com/.../kb-2120-totalcount-returns-incorrect-results
Thanks Zach, can we have this info updated on Query entity reference document. So that its easy for every one to know.
docs.appian.com/.../fnc_system_a_queryentity.html
Totally agree Ganesh, we should have it in documentation, as this is very frequent issue