a!queryEntity() Function

Executes a query on a given data store entity and returns the result.

Syntax

a!queryEntity( entity, query, fetchTotalCount )

  • entity (Data Store Entity): The Data Store Entity to query.
  • query (Query): The query definition of the report including grouping, aggregation, filtering, paging, and sorting configurations, created with a!query().
  • fetchTotalCount (Boolean): If set to false, avoids running the query that retrieves the total number of rows in the totalCount parameter of the resulting datasubset. If fetchTotalCount is set to false and batchSize is positive, totalCount is -1 to indicate its value is unknown. In cases where you don't need the total count, skipping this query can improve the performance of a!queryEntity(). Default: false.

Returns

DataSubset

Notes

The DataSubset returned by this function is used to generate report grids or graphs based on record data.

The entity value should be given as a constant of type Data Store Entity. The query value must be entered using the a!query() system function.

The logicalExpression|filter|search field of the query object can only be set to a LogicalExpression or a QueryFilter type. Search types are not supported.

The expression will fail to evaluate and an error will occur if the entity reference is not provided, invalid, or null, the user does not have permission to view the entity, the query value is not provided, invalid, incomplete, or an inconsistent query object.

This function allows a Query object with an array of SortInfo data type.

If fetchTotalCount is set to true and batchSize is 0 or positive, totalCount runs the query that retrieves the total number of rows. If fetchTotalCount is set to false and batchSize is positive, totalCount is -1 to indicate its value is unknown. In all other cases, the totalCount is set to the size of the datasubset.

If called multiple times in the same expression with the same parameters, only one query is made to the data store when the expression is evaluated and the result is reused for each identical call. This caching only applies within a single expression evaluation. Return values are not cached in separate expressions, or in separate evaluations of the same expression.

See Also

Data Store Entity: data store entities are named, typed storage units within a data store.

query: the query data type defines the grouping, aggregation, filtering, paging, and sorting configuration to be applied when querying data.

a!query(): A System Function that returns a Query object.

Querying Data From an RDBMS: An explanation of the differences between a!queryEntity, Query rules, and queryrecord().

Old Versions

There are older versions of this function. You can identify older versions by looking at the name to see if there is a version suffix. If you are using an old version, be sure to refer to the corresponding documentation from the list below.

Old Versions Reason for Update
a!queryEntity_18r3

Added the fetchTotalCount parameter, which, by default, avoids running the query that retrieves the total number of rows in the totalCount parameter of the resulting datasubset.

To learn more about how Appian handles this kind of versioning, see the Function and Component Versions page.

FEEDBACK