QueryEntity : fetchTotalCount Issue

Certified Senior Developer

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

Parents Reply Children
No Data