Сводные таблицы

Кэш, вычисляемые поля и элементы, группировка и детализация, макет, фильтры отчёта, сортировка и параметры полей значений. Операций на странице: 11.

Операции на этой странице — 11

pivot_cache_options
pivot_calculated_fields
pivot_calculated_items
pivot_data_model_olap_readonly
pivot_field_list_authoring
pivot_grouping_drilldown
pivot_layout_format
pivot_move_copy
pivot_report_filter_pages
pivot_sort_filter_ranking
pivot_value_field_settings

pivot_cache_options

Операция pivot cache options.

Request

Поле	Тип TypeScript	Обяз.
operation	“pivot_cache_options”	да
subsetId	string	да
requestId	string	да
intent	ContractPivotCacheOptionsAction	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · pivot_cache_options

Поле	Тип TypeScript	Обяз.
operation	“pivot_cache_options”	да
subsetId	string	да
requestId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	string	да
didChange	boolean	да
options	ContractPivotCacheOptionsView[]	да
refreshedPivotNames	string[]	да
dirtyCellCount	number	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

Минимальный JSON-шаблон

{
  "operation": "pivot_cache_options",
  "subsetId": "<subsetId>",
  "requestId": "<string>",
  "intent": "<ContractPivotCacheOptionsAction>",
  "requestedBackend": "native-desktop"
}

pivot_calculated_fields

Операция pivot calculated fields.

Request

Поле	Тип TypeScript	Обяз.
operation	“pivot_calculated_fields”	да
subsetId	string	да
intent	ContractPivotCalculatedFieldsAction	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · pivot_calculated_fields

Поле	Тип TypeScript	Обяз.
operation	“pivot_calculated_fields”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	string	да
caches	ContractPivotCalculatedCacheView[]	да
fields	ContractPivotCalculatedFieldView[]	да
refreshedCacheIds	string[]	да
dirtyCellCount	number	да
activeSheet	ContractActiveSheetMeta	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

Минимальный JSON-шаблон

{
  "operation": "pivot_calculated_fields",
  "subsetId": "<subsetId>",
  "intent": "<ContractPivotCalculatedFieldsAction>",
  "requestedBackend": "native-desktop"
}

pivot_calculated_items

Операция pivot calculated items.

Request

Поле	Тип TypeScript	Обяз.
operation	“pivot_calculated_items”	да
subsetId	string	да
intent	ContractPivotCalculatedItemsAction	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · pivot_calculated_items

Поле	Тип TypeScript	Обяз.
operation	“pivot_calculated_items”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	string	да
fields	ContractPivotCalculatedItemFieldView[]	да
items	ContractPivotCalculatedItemView[]	да
refreshedCacheIds	string[]	да
dirtyCellCount	number	да
activeSheet	ContractActiveSheetMeta	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

Минимальный JSON-шаблон

{
  "operation": "pivot_calculated_items",
  "subsetId": "<subsetId>",
  "intent": "<ContractPivotCalculatedItemsAction>",
  "requestedBackend": "native-desktop"
}

pivot_data_model_olap_readonly

Операция pivot data model olap readonly.

Request

Поле	Тип TypeScript	Обяз.
operation	“pivot_data_model_olap_readonly”	да
subsetId	string	да
requestId	string	да
intent	ContractPivotDataModelOlapReadonlyAction	да
requestedBackend	ComputeBackendKind \| null	нет

Success payload · pivot_data_model_olap_readonly

Поле	Тип TypeScript	Обяз.
operation	“pivot_data_model_olap_readonly”	да
subsetId	string	да
requestId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	“ok” \| “blocked”	да
didChange	false	да
blockedReasonCode	string \| null	да
selectedEntityStableId	string \| null	да
inventory	ContractPivotDataModelOlapInventory	да

Минимальный JSON-шаблон

{
  "operation": "pivot_data_model_olap_readonly",
  "subsetId": "<subsetId>",
  "requestId": "<string>",
  "intent": "<ContractPivotDataModelOlapReadonlyAction>",
  "requestedBackend": "native-desktop"
}

pivot_field_list_authoring

Операция pivot field list authoring.

Request

Поле	Тип TypeScript	Обяз.
operation	“pivot_field_list_authoring”	да
subsetId	string	да
requestId	string	да
intent	ContractPivotFieldListAuthoringAction	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · pivot_field_list_authoring

Поле	Тип TypeScript	Обяз.
operation	“pivot_field_list_authoring”	да
subsetId	string	да
requestId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	string	да
didChange	boolean	да
draftChanged	boolean	да
layouts	ContractPivotFieldListView[]	да
dirtyCellCount	number	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

Минимальный JSON-шаблон

{
  "operation": "pivot_field_list_authoring",
  "subsetId": "<subsetId>",
  "requestId": "<string>",
  "intent": "<ContractPivotFieldListAuthoringAction>",
  "requestedBackend": "native-desktop"
}

pivot_grouping_drilldown

Операция pivot grouping drilldown.

Request

Поле	Тип TypeScript	Обяз.
operation	“pivot_grouping_drilldown”	да
subsetId	string	да
requestId	string	да
intent	ContractPivotGroupingDrilldownAction	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · pivot_grouping_drilldown

Поле	Тип TypeScript	Обяз.
operation	“pivot_grouping_drilldown”	да
subsetId	string	да
requestId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	string	да
didChange	boolean	да
caches	ContractPivotGroupingCacheView[]	да
items	ContractPivotGroupingItemView[]	да
groups	ContractPivotGroupView[]	да
expandedItems	ContractPivotExpandedItemView[]	да
hierarchyNodes	ContractPivotHierarchyNodeView[]	да
refreshedPivotNames	string[]	да
detailContext	ContractPivotDetailContextView \| null	нет
getPivotData	ContractPivotGetPivotDataView \| null	нет
detailSheetLineage	ContractPivotDetailLineageView \| null	нет
dirtyCellCount	number	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

Минимальный JSON-шаблон

{
  "operation": "pivot_grouping_drilldown",
  "subsetId": "<subsetId>",
  "requestId": "<string>",
  "intent": "<ContractPivotGroupingDrilldownAction>",
  "requestedBackend": "native-desktop"
}

pivot_layout_format

Операция pivot layout format.

Request

Поле	Тип TypeScript	Обяз.
operation	“pivot_layout_format”	да
subsetId	string	да
requestId	string	да
intent	ContractPivotLayoutFormatAction	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · pivot_layout_format

Поле	Тип TypeScript	Обяз.
operation	“pivot_layout_format”	да
subsetId	string	да
requestId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	string	да
didChange	boolean	да
layouts	ContractPivotLayoutFormatView[]	да
refreshedPivotNames	string[]	да
dirtyCellCount	number	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

Минимальный JSON-шаблон

{
  "operation": "pivot_layout_format",
  "subsetId": "<subsetId>",
  "requestId": "<string>",
  "intent": "<ContractPivotLayoutFormatAction>",
  "requestedBackend": "native-desktop"
}

pivot_move_copy

Операция pivot move copy.

Request

Поле	Тип TypeScript	Обяз.
operation	“pivot_move_copy”	да
subsetId	string	да
requestId	string	да
intent	ContractPivotMoveCopyAction	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · pivot_move_copy

Поле	Тип TypeScript	Обяз.
operation	“pivot_move_copy”	да
subsetId	string	да
requestId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	string	да
didChange	boolean	да
pivots	ContractPivotMoveCopyView[]	да
destinationSheets	ContractPivotMoveCopySheetView[]	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

Минимальный JSON-шаблон

{
  "operation": "pivot_move_copy",
  "subsetId": "<subsetId>",
  "requestId": "<string>",
  "intent": "<ContractPivotMoveCopyAction>",
  "requestedBackend": "native-desktop"
}

pivot_report_filter_pages

Операция pivot report filter pages.

Request

Поле	Тип TypeScript	Обяз.
operation	“pivot_report_filter_pages”	да
subsetId	string	да
requestId	string	да
intent	ContractPivotReportFilterPagesAction	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · pivot_report_filter_pages

Поле	Тип TypeScript	Обяз.
operation	“pivot_report_filter_pages”	да
subsetId	string	да
requestId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	string	да
didChange	boolean	да
reports	ContractPivotReportFilterView[]	да
generatedPages	ContractPivotReportFilterPageView[]	да
refreshedPivotNames	string[]	да
dirtyCellCount	number	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

Минимальный JSON-шаблон

{
  "operation": "pivot_report_filter_pages",
  "subsetId": "<subsetId>",
  "requestId": "<string>",
  "intent": "<ContractPivotReportFilterPagesAction>",
  "requestedBackend": "native-desktop"
}

pivot_sort_filter_ranking

Операция pivot sort filter ranking.

Request

Поле	Тип TypeScript	Обяз.
operation	“pivot_sort_filter_ranking”	да
subsetId	string	да
requestId	string	да
intent	ContractPivotSortFilterAction	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · pivot_sort_filter_ranking

Поле	Тип TypeScript	Обяз.
operation	“pivot_sort_filter_ranking”	да
subsetId	string	да
requestId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	string	да
didChange	boolean	да
fields	ContractPivotSortFilterView[]	да
refreshedPivotNames	string[]	да
dirtyCellCount	number	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

Минимальный JSON-шаблон

{
  "operation": "pivot_sort_filter_ranking",
  "subsetId": "<subsetId>",
  "requestId": "<string>",
  "intent": "<ContractPivotSortFilterAction>",
  "requestedBackend": "native-desktop"
}

pivot_value_field_settings

Операция pivot value field settings.

Request

Поле	Тип TypeScript	Обяз.
operation	“pivot_value_field_settings”	да
subsetId	string	да
requestId	string	да
intent	ContractPivotValueFieldSettingsAction	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · pivot_value_field_settings

Поле	Тип TypeScript	Обяз.
operation	“pivot_value_field_settings”	да
subsetId	string	да
requestId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	string	да
didChange	boolean	да
valueFields	ContractPivotValueFieldSettingsView[]	да
refreshedPivotNames	string[]	да
dirtyCellCount	number	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

Минимальный JSON-шаблон

{
  "operation": "pivot_value_field_settings",
  "subsetId": "<subsetId>",
  "requestId": "<string>",
  "intent": "<ContractPivotValueFieldSettingsAction>",
  "requestedBackend": "native-desktop"
}