Table Layout Technical Reference
Summary
- Layout State enables Table Layouts to be configured
Find Out More
See General Layouts Technical Reference for details on Layout Options and Layout API
Layout State
Layout State contains a collection of Layouts and the Current Layout:
| Property | Description |
|---|---|
| CurrentLayout | Layout to be loaded when AdapTable starts (using Name property in Layout); if not provided the first Layout is used |
| Layouts | Collection of Layouts - can be Table or Pivot |
Base Layout Object
Table Layouts derive from the LayoutBase object defined as follows:
| Property | Description |
|---|---|
| AutoSizeColumns | Whether Columns should autosize when Layout first loads |
| ColumnFilters | Collection of Column Filters to apply in Layout |
| ColumnGroupValues | Defines which Column Groups are expanded / collapsed |
| ColumnHeaders | Set of custom header names for some (or all) Columns |
| ColumnPinning | Details of which Columns are pinned |
| ColumnSizing | Controls size (width or flex & min/max) for Columns |
| ColumnSorts | Sorting to apply in the Layout |
| GrandTotalRow | Position of the Grand Total Row in the Layout |
| GridFilter | Grid Filter to apply in Layout |
| Name | Name of the Layout as it appears in the Layout toolbar and tool panel |
| RowGroupDisplayType | Display Row Grouped Columns as 'single' or 'multi' column |
| RowGroupValues | Defines which Row Groups are expanded / collapsed |
| SuppressAggFuncInHeader | Hides the aggFunc in Column header: e.g. 'sum(Price)' becomes 'Price' |
| IsReadOnly | Sets Entity to ReadOnly (overwriting a Strategy Entitlement of 'Full') |
Table Layout Object
The Table Layout additionally includes these properties:
| Property | Description |
|---|---|
| ColumnVisibility | Map of Table Column Visibility |
| RowGroupedColumns | Columns which are row-grouped when the Layout is applied |
| RowSummaries | Pinned Rows that display Aggregation Info for a whole Column |
| TableAggregationColumns | Columns showing aggregated values in Grouped Rows; a record of ColumnId and aggfunc (e.g. sum) or 'true' (to use default aggfunc) |
| TableColumns | List of Column Ids to include in Table Layout |
| IsReadOnly | Sets Entity to ReadOnly (overwriting a Strategy Entitlement of 'Full') |
Column Filter
The ColumnFilters property is a collection of ColumnFilter objects defined as follows:
| Property | Description | Default |
|---|---|---|
| ColumnId | Column where Filter should be applied | |
| Predicates | AdaptablePredicate which AdaptableQL will evaluate when the Filter is run | |
| PredicatesOperator | Logic used when combining multiple Predicates ('AND'|'OR') | 'AND' |
| IsReadOnly | Sets Entity to ReadOnly (overwriting a Strategy Entitlement of 'Full') | |
| IsSuspended | Suspends (i.e. turns off) an Adaptable Object |
Grid Filter
The GridFilter object is defined as follows:
| Property | Description |
|---|---|
| Expression | The (boolean) Expression to run |
| IsReadOnly | Sets Entity to ReadOnly (overwriting a Strategy Entitlement of 'Full') |
| IsSuspended | Suspends (i.e. turns off) an Adaptable Object |
Column Sort
The ColumnSort object used for sorting is defined as follows:
| Property | Description |
|---|---|
| ColumnId | Id of Column being sorted |
| SortOrder | How Column is sorted - either 'Asc' or 'Desc' |
Other Table Layout Properties
| Property | Type |
|---|---|
ColumnPinning | ColumnDirectionMap |
ColumnSizing | ColumnSizingMap |
ColumnVisibility | ColumnBooleanFalseMap |
ColumnHeaders | ColumnStringMap |
RowGroupValues | RowGroupValues |
ColumnGroupValues | ColumnGroupValues |
Note
RowGroupValuescontains exceptions of typeRowGroupValuesWithExceptionKeysColumnGroupValuescontains exceptions of typeColumnGroupValuesWithExceptionKeys