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

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

Операции на этой странице — 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

Запрос

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

Ответ при успехе · 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

Запрос

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

Ответ при успехе · 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

Запрос

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

Ответ при успехе · 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

Запрос

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

Ответ при успехе · 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

Запрос

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

Ответ при успехе · 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

Запрос

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

Ответ при успехе · 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

Запрос

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

Ответ при успехе · 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

Запрос

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

Ответ при успехе · 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

Запрос

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

Ответ при успехе · 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

Запрос

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

Ответ при успехе · 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

Запрос

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

Ответ при успехе · 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"
}