You are currently reviewing an older revision of this page.

DRAFT KB-[SP-3142] totalCount returns incorrect results when querying a view

Symptoms

When querying a view, the "totalCount"

Cause

Expected behavior since fetchTotalCount determines results based on primary keys, and the primary key isn't unique

Action

Update view to have unique primary keys.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: May 2020