When using a!queryEntity without a sortInfo parameter specified, a seemingly arbitrary sort order is applied to the data. Specifically, the following behaviors are seen:
a!queryEntity
sortInfo
a!querySelection
a!queryColumn
As a result of this, performance issues may be observed if the query returns a lot of data or is sorting by a text column.
This issue has been reported to the Appian Product Team. The reference number for this issue is AN-128642.
Sorting by the primary key is typically the most efficient sort order. Thus, a sort parameter referencing the primary key should be set for the pagingInfo used by the queryEntity.
sort
pagingInfo
queryEntity
This article applies to all versions of Appian.
Last Reviewed: May 2019