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:

PropertyDescription
CurrentLayoutLayout to be loaded when AdapTable starts (using Name property in Layout); if not provided the first Layout is used
LayoutsCollection of Layouts - can be Table or Pivot

Base Layout Object

Table Layouts derive from the LayoutBase object defined as follows:

PropertyDescription
AutoSizeColumnsWhether Columns should autosize when Layout first loads
ColumnFiltersCollection of Column Filters to apply in Layout
ColumnGroupValuesDefines which Column Groups are expanded / collapsed
ColumnHeadersSet of custom header names for some (or all) Columns
ColumnPinningDetails of which Columns are pinned
ColumnSizingControls size (width or flex & min/max) for Columns
ColumnSortsSorting to apply in the Layout
GrandTotalRowPosition of the Grand Total Row in the Layout
GridFilterGrid Filter to apply in Layout
NameName of the Layout as it appears in the Layout toolbar and tool panel
RowGroupDisplayTypeDisplay Row Grouped Columns as 'single' or 'multi' column
RowGroupValuesDefines which Row Groups are expanded / collapsed
SuppressAggFuncInHeaderHides the aggFunc in Column header: e.g. 'sum(Price)' becomes 'Price'
IsReadOnlySets Entity to ReadOnly (overwriting a Strategy Entitlement of 'Full')

Table Layout Object

The Table Layout additionally includes these properties:

PropertyDescription
ColumnVisibilityMap of Table Column Visibility
RowGroupedColumnsColumns which are row-grouped when the Layout is applied
RowSummariesPinned Rows that display Aggregation Info for a whole Column
TableAggregationColumnsColumns showing aggregated values in Grouped Rows; a record of ColumnId and aggfunc (e.g. sum) or 'true' (to use default aggfunc)
TableColumnsList of Column Ids to include in Table Layout
IsReadOnlySets Entity to ReadOnly (overwriting a Strategy Entitlement of 'Full')

Column Filter

The ColumnFilters property is a collection of ColumnFilter objects defined as follows:

PropertyDescriptionDefault
ColumnIdColumn where Filter should be applied
PredicatesAdaptablePredicate which AdaptableQL will evaluate when the Filter is run
PredicatesOperatorLogic used when combining multiple Predicates ('AND'|'OR')'AND'
IsReadOnlySets Entity to ReadOnly (overwriting a Strategy Entitlement of 'Full')
IsSuspendedSuspends (i.e. turns off) an Adaptable Object

Grid Filter

The GridFilter object is defined as follows:

PropertyDescription
ExpressionThe (boolean) Expression to run
IsReadOnlySets Entity to ReadOnly (overwriting a Strategy Entitlement of 'Full')
IsSuspendedSuspends (i.e. turns off) an Adaptable Object

Column Sort

The ColumnSort object used for sorting is defined as follows:

PropertyDescription
ColumnIdId of Column being sorted
SortOrderHow Column is sorted - either 'Asc' or 'Desc'

Other Table Layout Properties

PropertyType
ColumnPinningColumnDirectionMap
ColumnSizingColumnSizingMap
ColumnVisibilityColumnBooleanFalseMap
ColumnHeadersColumnStringMap
RowGroupValuesRowGroupValues
ColumnGroupValuesColumnGroupValues

Note