Skip to main content

DomainAggregateSpec<TColumn, TGroup, TAlias>

Defined in: js-api/src/domains.ts:508

Spec for domain table aggregate: a DomainReadScope (the rows aggregated — search and deleted narrow it exactly as they narrow DomainQuerySpec) plus the grouping.

Extends​

Type Parameters​

Type ParameterDefault type
TColumn extends stringstring
TGroup extends stringstring
TAlias extends stringstring

Properties​

PropertyTypeDescriptionInherited fromDefined in
deleted?"exclude" | "include" | "only"Soft-deleted rows: 'exclude' (the default — only live rows), 'include' (both) or 'only' (the trash). Anything but 'exclude' also projects ~is_deleted (DOMAIN_SERVICE_COLUMNS); a deleted row is read-only until DomainTableClient.restore brings it back. Needs DomainSupport.deleted.DomainReadScope.deletedjs-api/src/domains.ts:456
expand?string[]Master-FK expands ('<fk_column>'); groupBy/measures may then use '<fk>.<col>' (§13.2).-js-api/src/domains.ts:518
filter?DomainFilter<TColumn>Smart-filter string (same grammar as entity search, e.g. barcode starts "P-1"), a single condition, or the canonical condition tree — values are bound server-side. Row caps: JSON query 10k, d42 queryDf 10M.DomainReadScope.filterjs-api/src/domains.ts:447
groupBy?DomainColumnRef<TColumn> & TGroup[]Column names to group by; omit for a single-row grand total.-js-api/src/domains.ts:512
limit?number--js-api/src/domains.ts:516
measuresDomainAggregateMeasure<TColumn, TAlias>[]--js-api/src/domains.ts:513
search?stringCase-insensitive substring over the table's searchable columns — those declared searchable: true, else the name column (DomainTableInfo.searchableColumns); a table with neither rejects with a filter error. ANDed with filter.DomainReadScope.searchjs-api/src/domains.ts:451
sort?stringComma-separated output names (group columns or measure aliases); ! prefix for descending.-js-api/src/domains.ts:515