Method getTableData

server/charts/TableView.js:44–154

(data, chartData, timezone = "")

class TableView {
  getTableData(data, chartData, timezone = "") {
    const rawData = data.configuration;
    const tabularData = {};
    const datasetConfigs = chartData.chart?.ChartDatasetConfigs;

    Object.keys(rawData).forEach((key, datasetIndex) => {
      const tab = { columns: [], data: [] };
      const dataset = rawData[key];

      // Pre-compute dataset config and excluded fields
      const datasetConfig = datasetConfigs?.[datasetIndex];
      const baseExcludedFields = chartData.datasets[datasetIndex].options.excludedFields || [];
      const excludedFields = datasetConfig?.excludedFields?.length > 0
        ? [...baseExcludedFields, ...datasetConfig.excludedFields]
        : baseExcludedFields;

      const excludedSet = new Set(excludedFields);
      const columnMap = new Map(); // Header -> index
      const nestedColumnMap = new Set(); // `${k}?${n}`
      const columnsFormatting = datasetConfig?.configuration?.columnsFormatting;

      // Process items in chunks to avoid blocking the event loop
      const chunkSize = 1000;
      for (let i = 0; i < dataset.length; i += chunkSize) {
        const chunk = dataset.slice(i, i + chunkSize);

        chunk.forEach((item) => {
          const dataItem = {};

          Object.entries(item).forEach(([k, val]) => {
            if (excludedSet.has(k)) return;

            const type = determineType(val);

            if (type === "object" && val && !Array.isArray(val)) {
              Object.entries(val).forEach(([n, nestedVal]) => {
                const headerKey = `${k}?${n}`;
                if (excludedSet.has(headerKey)) return;

                const nestedType = determineType(nestedVal);

                if (!columnMap.has(k)) {
                  columnMap.set(k, tab.columns.length);
                  tab.columns.push({ Header: k, accessor: k, columns: [] });
                }

                const colIndex = columnMap.get(k);
                if (!nestedColumnMap.has(headerKey)) {
                  nestedColumnMap.add(headerKey);
                  if (!tab.columns[colIndex].columns) tab.columns[colIndex].columns = [];
                  tab.columns[colIndex].columns.push({ Header: n, accessor: headerKey });
                }

                const columnConfig = columnsFormatting?.[headerKey];
                if (nestedType === "object") {
                  dataItem[headerKey] = `__cb_object${JSON.stringify(nestedVal)}`;
                } else if (nestedType === "array") {
                  dataItem[headerKey] = `__cb_array${JSON.stringify(nestedVal)}`;