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