Vue Data GridSSRM Transactions

Version 36.2.0

Enterprise

This section shows how rows can be added, removed and updated using the Server-Side Transaction API.

Server-Side Transactions require Row IDs to be supplied to grid.

Transaction API Copy Link

The SSRM Transaction API allows rows to be added, removed or updated in the grid:

Function

Apply transactions to the server side row model.

ServerSideRowModelApiModule

When the server-side store has a known last row index, remove transactions only delete rows that are currently in cache. If a delete is repeated or targets a row outside the loaded range, the grid ignores it and keeps the current store size. To explicitly set the new store size, provide rowCount on the transaction.

These operations are shown in the snippet below:

this.gridApi.applyServerSideTransaction({
    add: [
        { tradeId: 101, portfolio: 'Aggressive', product: 'Aluminium', book: 'GL-62472', current: 57969 }
    ],
    update: [
        { tradeId: 102,  portfolio: 'Aggressive', product: 'Aluminium', book: 'GL-624723', current: 58927 }
    ],
    remove: [
        { tradeId: 103 }
    ]
});

The following example demonstrates add / update and remove operations via the Server-Side Transaction API. Note the following:

When clicking any of the buttons, the console logs each transaction as it is applied to the grid.
Add Above Selected - adds a row above the selected row using the addIndex property as rows are added at the end by default.
Update Selected - updates the 'current' value on the selected row.
Removed Selected - removes the selected row.

main.ts

import {
  createApp,
  defineComponent,
  onBeforeMount,
  ref,
  shallowRef,
} from "vue";
import { AgGridVue } from "ag-grid-vue3";
import "./styles.css";
import {
  AutoGroupColumnDef,
  ColDef,
  ColGroupDef,
  GetRowIdFunc,
  GetRowIdParams,
  GridApi,
  GridOptions,
  GridReadyEvent,
  HighlightChangesModule,
  IServerSideGetRowsParams,
  ModuleRegistry,
  RowModelType,
  RowSelectionOptions,
  ServerSideTransaction,
  ServerSideTransactionResult,
  enableDevValidations,
} from "ag-grid-community";
import {
  ServerSideRowModelApiModule,
  ServerSideRowModelModule,
} from "ag-grid-enterprise";
import { data } from "./data";
import { FakeServer } from "./fakeServer";

if (process.env.NODE_ENV !== "production") {
  // Enable extended validations only for development
  enableDevValidations();
}

ModuleRegistry.registerModules([
  HighlightChangesModule,
  ServerSideRowModelModule,
  ServerSideRowModelApiModule,
]);

function getServerSideDatasource(server: any) {
  return {
    getRows: (params: IServerSideGetRowsParams) => {
      const response = server.getData(params.request);
      // adding delay to simulate real server call
      setTimeout(() => {
        if (response.success) {
          // call the success callback
          params.success({
            rowData: response.rows,
            rowCount: response.lastRow,
          });
        } else {
          // inform the grid request failed
          params.fail();
        }
      }, 300);
    },
  };
}

function logResults(
  transaction: ServerSideTransaction,
  result?: ServerSideTransactionResult,
) {
  console.log(
    "[Example] - Applied transaction:",
    transaction,
    "Result:",
    result,
  );
}

function getNewValue() {
  return Math.floor(window.agRandom() * 100000) + 100;
}

let serverCurrentTradeId = data.length;

function createRow() {
  return {
    portfolio: "Aggressive",
    product: "Aluminium",
    book: "GL-62472",
    tradeId: ++serverCurrentTradeId,
    current: getNewValue(),
  };
}

const VueExample = defineComponent({
  template: `
        <div style="height: 100%">
                <div class="example-wrapper">
      <div style="margin-bottom: 5px">
        <button v-on:click="addRow()">Add Above Selected</button>
        <button v-on:click="updateRow()">Update Selected</button>
        <button v-on:click="removeRow()">Remove Selected</button>
      </div>
      <ag-grid-vue
        style="width: 100%; height: 100%;"
        @grid-ready="onGridReady"
        :columnDefs="columnDefs"
        :defaultColDef="defaultColDef"
        :autoGroupColumnDef="autoGroupColumnDef"
        :getRowId="getRowId"
        :rowSelection="rowSelection"
        :rowModelType="rowModelType"
        :rowData="rowData"></ag-grid-vue>
      </div>
        </div>
    `,
  components: {
    "ag-grid-vue": AgGridVue,
  },
  setup(props) {
    const gridApi = shallowRef<GridApi | null>(null);
    const columnDefs = ref<ColDef[]>([
      { field: "tradeId" },
      { field: "portfolio" },
      { field: "book" },
      { field: "current" },
    ]);
    const defaultColDef = ref<ColDef>({
      flex: 1,
      minWidth: 100,
      enableCellChangeFlash: true,
    });
    const autoGroupColumnDef = ref<AutoGroupColumnDef>({
      minWidth: 220,
    });
    const getRowId = ref<GetRowIdFunc>(
      (params: GetRowIdParams) => `${params.data.tradeId}`,
    );
    const rowSelection = ref<RowSelectionOptions | "single" | "multiple">({
      mode: "singleRow",
    });
    const rowModelType = ref<RowModelType>("serverSide");
    const rowData = ref<any[]>(null);

    function addRow() {
      const selectedRows = gridApi.value!.getSelectedNodes();
      if (selectedRows.length === 0) {
        console.log("[Example] No row selected.");
        return;
      }
      const rowIndex = selectedRows[0].rowIndex;
      const transaction: ServerSideTransaction = {
        addIndex: rowIndex != null ? rowIndex : undefined,
        add: [createRow()],
      };
      const result = gridApi.value!.applyServerSideTransaction(transaction);
      logResults(transaction, result);
    }
    function updateRow() {
      const selectedRows = gridApi.value!.getSelectedNodes();
      if (selectedRows.length === 0) {
        console.log("[Example] No row selected.");
        return;
      }
      const transaction: ServerSideTransaction = {
        update: [{ ...selectedRows[0].data, current: getNewValue() }],
      };
      const result = gridApi.value!.applyServerSideTransaction(transaction);
      logResults(transaction, result);
    }
    function removeRow() {
      const selectedRows = gridApi.value!.getSelectedNodes();
      if (selectedRows.length === 0) {
        console.log("[Example] No row selected.");
        return;
      }
      const transaction: ServerSideTransaction = {
        remove: [selectedRows[0].data],
      };
      const result = gridApi.value!.applyServerSideTransaction(transaction);
      logResults(transaction, result);
    }
    const onGridReady = (params: GridReadyEvent) => {
      gridApi.value = params.api;

      // setup the fake server
      const server = new FakeServer(data);
      // create datasource with a reference to the fake server
      const datasource = getServerSideDatasource(server);
      // register the datasource with the grid
      params.api.setGridOption("serverSideDatasource", datasource);
    };

    return {
      gridApi,
      columnDefs,
      defaultColDef,
      autoGroupColumnDef,
      getRowId,
      rowSelection,
      rowModelType,
      rowData,
      onGridReady,
      addRow,
      updateRow,
      removeRow,
    };
  },
});

const app = createApp(VueExample);
app.mount("#app");

Row Grouping Copy Link

To use transactions while using row grouping, transactions need to be applied to the specific row group. This is done by providing a route when applying the transaction. It is also necessary to inform the grid when group rows are updated, added or removed.

The snippet below demonstrates creating a group row transaction for rows which are the first of their group, as the leaf rows will be requested via getRows when the group is expanded.

// create the group row at the root level (only if it's the first row for this group)
this.gridApi.applyServerSideTransaction({
	route: [],
	add: [{ portfolio: 'Aggressive' }]
});

// otherwise, create the leaf node inside of the 'Aggressive' group
this.gridApi.applyServerSideTransaction({
	route: ['Aggressive'],
	add: [row]
});

In the example below, note the following:

When clicking any of the buttons, the console logs each transaction as it is applied to the grid.
To add a new row, if the group didn't previously exist, then the route is omitted and the group row is added. If it did previously exist, then the group route is provided and the leaf node is added.
To delete a row, if the group row would be deleted then a transaction needs to be applied to remove this group row instead of the leaf row.
To move a row between groups, the row needs to be deleted from the old group with one transaction, and added to the new group with another.

main.ts

import {
  createApp,
  defineComponent,
  onBeforeMount,
  ref,
  shallowRef,
} from "vue";
import { AgGridVue } from "ag-grid-vue3";
import "./styles.css";
import {
  AutoGroupColumnDef,
  ColDef,
  ColGroupDef,
  GetRowIdFunc,
  GetRowIdParams,
  GridApi,
  GridOptions,
  GridReadyEvent,
  HighlightChangesModule,
  IServerSideGetRowsParams,
  IsServerSideGroupOpenByDefault,
  IsServerSideGroupOpenByDefaultParams,
  ModuleRegistry,
  RowModelType,
  ServerSideTransaction,
  ServerSideTransactionResult,
  enableDevValidations,
} from "ag-grid-community";
import {
  RowGroupingModule,
  ServerSideRowModelApiModule,
  ServerSideRowModelModule,
} from "ag-grid-enterprise";
import {
  changePortfolioOnServer,
  createRowOnServer,
  data,
  deletePortfolioOnServer,
} from "./data";
import { FakeServer } from "./fakeServer";

if (process.env.NODE_ENV !== "production") {
  // Enable extended validations only for development
  enableDevValidations();
}

ModuleRegistry.registerModules([
  HighlightChangesModule,
  RowGroupingModule,
  ServerSideRowModelModule,
  ServerSideRowModelApiModule,
]);

function getServerSideDatasource(server: any) {
  return {
    getRows: (params: IServerSideGetRowsParams) => {
      const response = server.getData(params.request);
      // adding delay to simulate real server call
      setTimeout(() => {
        if (response.success) {
          // call the success callback
          params.success({
            rowData: response.rows,
            rowCount: response.lastRow,
          });
        } else {
          // inform the grid request failed
          params.fail();
        }
      }, 300);
    },
  };
}

function logResults(
  transaction: ServerSideTransaction,
  result?: ServerSideTransactionResult,
) {
  console.log(
    "[Example] - Applied transaction:",
    transaction,
    "Result:",
    result,
  );
}

const VueExample = defineComponent({
  template: `
        <div style="height: 100%">
                <div class="example-wrapper">
      <div style="margin-bottom: 5px">
        <button v-on:click="createOneAggressive()">Add new 'Aggressive'</button>
        <button v-on:click="updateAggressiveToHybrid()">Move all 'Aggressive' to 'Hybrid'</button>
        <button v-on:click="deleteAllHybrid()">Remove all 'Hybrid'</button>
      </div>
      <ag-grid-vue
        style="width: 100%; height: 100%;"
        @grid-ready="onGridReady"
        :columnDefs="columnDefs"
        :defaultColDef="defaultColDef"
        :autoGroupColumnDef="autoGroupColumnDef"
        :isServerSideGroupOpenByDefault="isServerSideGroupOpenByDefault"
        :getRowId="getRowId"
        :rowModelType="rowModelType"
        :rowData="rowData"></ag-grid-vue>
      </div>
        </div>
    `,
  components: {
    "ag-grid-vue": AgGridVue,
  },
  setup(props) {
    const gridApi = shallowRef<GridApi | null>(null);
    const columnDefs = ref<ColDef[]>([
      { field: "tradeId" },
      { field: "portfolio", hide: true, rowGroup: true },
      { field: "book" },
      { field: "previous" },
      { field: "current" },
    ]);
    const defaultColDef = ref<ColDef>({
      flex: 1,
      minWidth: 100,
      enableCellChangeFlash: true,
    });
    const autoGroupColumnDef = ref<AutoGroupColumnDef>({
      minWidth: 220,
    });
    const isServerSideGroupOpenByDefault = ref<IsServerSideGroupOpenByDefault>(
      (params: IsServerSideGroupOpenByDefaultParams) => {
        return (
          params.rowNode.key === "Aggressive" || params.rowNode.key === "Hybrid"
        );
      },
    );
    const getRowId = ref<GetRowIdFunc>((params: GetRowIdParams) => {
      if (params.level === 0) {
        return params.data.portfolio;
      }
      return String(params.data.tradeId);
    });
    const rowModelType = ref<RowModelType>("serverSide");
    const rowData = ref<any[]>(null);

    function deleteAllHybrid() {
      // NOTE: real applications would be better served listening to a stream of changes from the server instead
      const serverResponse: any = deletePortfolioOnServer("Hybrid");
      if (!serverResponse.success) {
        console.warn("Nothing has changed on the server");
        return;
      }
      if (serverResponse) {
        // apply tranaction to keep grid in sync
        const transaction = {
          remove: [{ portfolio: "Hybrid" }],
        };
        const result = gridApi.value!.applyServerSideTransaction(transaction);
        logResults(transaction, result);
      }
    }
    function createOneAggressive() {
      // NOTE: real applications would be better served listening to a stream of changes from the server instead
      const serverResponse: any = createRowOnServer(
        "Aggressive",
        "Aluminium",
        "GL-1",
      );
      if (!serverResponse.success) {
        console.warn("Nothing has changed on the server");
        return;
      }
      if (serverResponse.newGroupCreated) {
        // if a new group had to be created, reflect in the grid
        const transaction = {
          route: [],
          add: [{ portfolio: "Aggressive" }],
        };
        const result = gridApi.value!.applyServerSideTransaction(transaction);
        logResults(transaction, result);
      } else {
        // if the group already existed, add rows to it
        const transaction = {
          route: ["Aggressive"],
          add: [serverResponse.newRecord],
        };
        const result = gridApi.value!.applyServerSideTransaction(transaction);
        logResults(transaction, result);
      }
    }
    function updateAggressiveToHybrid() {
      // NOTE: real applications would be better served listening to a stream of changes from the server instead
      const serverResponse: any = changePortfolioOnServer(
        "Aggressive",
        "Hybrid",
      );
      if (!serverResponse.success) {
        console.warn("Nothing has changed on the server");
        return;
      }
      const transaction = {
        remove: [{ portfolio: "Aggressive" }],
      };
      // aggressive group no longer exists, so delete the group
      const result = gridApi.value!.applyServerSideTransaction(transaction);
      logResults(transaction, result);
      if (serverResponse.newGroupCreated) {
        // hybrid group didn't exist, so just create the new group
        const t = {
          route: [],
          add: [{ portfolio: "Hybrid" }],
        };
        const r = gridApi.value!.applyServerSideTransaction(t);
        logResults(t, r);
      } else {
        // hybrid group already existed, add rows to it
        const t = {
          route: ["Hybrid"],
          add: serverResponse.updatedRecords,
        };
        const r = gridApi.value!.applyServerSideTransaction(t);
        logResults(t, r);
      }
    }
    const onGridReady = (params: GridReadyEvent) => {
      gridApi.value = params.api;

      // setup the fake server
      const server = new FakeServer(data);
      // create datasource with a reference to the fake server
      const datasource = getServerSideDatasource(server);
      // register the datasource with the grid
      params.api.setGridOption("serverSideDatasource", datasource);
    };

    return {
      gridApi,
      columnDefs,
      defaultColDef,
      autoGroupColumnDef,
      isServerSideGroupOpenByDefault,
      getRowId,
      rowModelType,
      rowData,
      onGridReady,
      deleteAllHybrid,
      createOneAggressive,
      updateAggressiveToHybrid,
    };
  },
});

const app = createApp(VueExample);
app.mount("#app");

Asynchronous Updates Copy Link

When processing many updates rapidly, the grid will perform more smoothly if the changes are batched (as this can prevent excessive rendering). The grid can batch these changes for you without negatively impacting the user experience, and in most cases improving it.

Function

Batch apply transactions to the server side row model.

ServerSideRowModelApiModule

When using asynchronous transactions, the grid delays any transactions received within a time window (specified using asyncTransactionWaitMillis) and executes them together when the window has passed.

The snippet below demonstrates three asynchronous transactions applied sequentially, however because these transactions are asynchronously batched, the grid would only update the DOM once.

// due to asynchronous batching, the following transactions are applied together preventing unnecessary DOM updates
this.gridApi.applyServerSideTransactionAsync({
    add: [{ tradeId: 101, portfolio: 'Aggressive', product: 'Aluminium', book: 'GL-62472', current: 57969 }],
});
this.gridApi.applyServerSideTransactionAsync({
    update: [{ tradeId: 102,  portfolio: 'Aggressive', product: 'Aluminium', book: 'GL-624723', current: 58927 }],
});
this.gridApi.applyServerSideTransactionAsync({
    remove: [{ tradeId: 103 }],
});

In the example below, note the following:

After starting the updates, 1 row is created, 10 rows are updated, and 1 row is deleted every 10 milliseconds.
The transactions are batched, and only executed once every second.

main.ts

import {
  createApp,
  defineComponent,
  onBeforeMount,
  ref,
  shallowRef,
} from "vue";
import { AgGridVue } from "ag-grid-vue3";
import "./styles.css";
import {
  AutoGroupColumnDef,
  ColDef,
  ColGroupDef,
  GetRowIdFunc,
  GetRowIdParams,
  GridApi,
  GridOptions,
  GridReadyEvent,
  HighlightChangesModule,
  IServerSideGetRowsParams,
  ModuleRegistry,
  RowModelType,
  ServerSideTransaction,
  enableDevValidations,
} from "ag-grid-community";
import {
  ServerSideRowModelApiModule,
  ServerSideRowModelModule,
} from "ag-grid-enterprise";
import { data, dataObservers, randomUpdates } from "./data";
import { FakeServer } from "./fakeServer";

if (process.env.NODE_ENV !== "production") {
  // Enable extended validations only for development
  enableDevValidations();
}

ModuleRegistry.registerModules([
  HighlightChangesModule,
  ServerSideRowModelModule,
  ServerSideRowModelApiModule,
]);

function getServerSideDatasource(server: any) {
  return {
    getRows: (params: IServerSideGetRowsParams) => {
      const response = server.getData(params.request);
      // adding delay to simulate real server call
      setTimeout(() => {
        if (response.success) {
          // call the success callback
          params.success({
            rowData: response.rows,
            rowCount: response.lastRow,
          });
        } else {
          // inform the grid request failed
          params.fail();
        }
      }, 300);
    },
  };
}

let interval: any;

function disable(id: string, disabled: boolean) {
  document.querySelector<HTMLInputElement>(id)!.disabled = disabled;
}

const VueExample = defineComponent({
  template: `
        <div style="height: 100%">
                <div class="example-wrapper">
      <div style="margin-bottom: 5px">
        <button id="startUpdates" v-on:click="startUpdates()">Start Updates</button>
        <button id="stopUpdates" v-on:click="stopUpdates()">Stop Updates</button>
      </div>
      <ag-grid-vue
        style="width: 100%; height: 100%;"
        @grid-ready="onGridReady"
        :columnDefs="columnDefs"
        :defaultColDef="defaultColDef"
        :autoGroupColumnDef="autoGroupColumnDef"
        :getRowId="getRowId"
        :asyncTransactionWaitMillis="asyncTransactionWaitMillis"
        :rowModelType="rowModelType"
        :rowData="rowData"></ag-grid-vue>
      </div>
        </div>
    `,
  components: {
    "ag-grid-vue": AgGridVue,
  },
  setup(props) {
    const gridApi = shallowRef<GridApi | null>(null);
    const columnDefs = ref<ColDef[]>([
      { field: "tradeId" },
      { field: "portfolio" },
      { field: "book" },
      { field: "previous" },
      { field: "current" },
      {
        field: "lastUpdated",
        wrapHeaderText: true,
        autoHeaderHeight: true,
        valueFormatter: (params) => {
          const ts = params.data!.lastUpdated;
          if (ts) {
            const hh_mm_ss = ts.toLocaleString().split(" ")[1];
            const SSS = ts.getMilliseconds();
            return `${hh_mm_ss}:${SSS}`;
          }
          return "";
        },
      },
      { field: "updateCount" },
    ]);
    const defaultColDef = ref<ColDef>({
      flex: 1,
      minWidth: 100,
      enableCellChangeFlash: true,
    });
    const autoGroupColumnDef = ref<AutoGroupColumnDef>({
      minWidth: 220,
    });
    const getRowId = ref<GetRowIdFunc>((params: GetRowIdParams) => {
      let rowId = "";
      if (params.parentKeys && params.parentKeys.length) {
        rowId += params.parentKeys.join("-") + "-";
      }
      if (params.data.tradeId != null) {
        rowId += params.data.tradeId;
      }
      return rowId;
    });
    const asyncTransactionWaitMillis = ref(1000);
    const rowModelType = ref<RowModelType>("serverSide");
    const rowData = ref<any[]>(null);

    function startUpdates() {
      interval = setInterval(
        () => randomUpdates({ numUpdate: 10, numAdd: 1, numRemove: 1 }),
        10,
      );
      disable("#stopUpdates", false);
      disable("#startUpdates", true);
    }
    function stopUpdates() {
      if (interval !== undefined) {
        clearInterval(interval);
      }
      disable("#stopUpdates", true);
      disable("#startUpdates", false);
    }
    const onGridReady = (params: GridReadyEvent) => {
      gridApi.value = params.api;

      disable("#stopUpdates", true);
      // setup the fake server
      const server = FakeServer(data);
      // create datasource with a reference to the fake server
      const datasource = getServerSideDatasource(server);
      // register the datasource with the grid
      params.api.setGridOption("serverSideDatasource", datasource);
      // register interest in data changes
      dataObservers.push((t: ServerSideTransaction) => {
        params.api.applyServerSideTransactionAsync(t);
      });
    };

    return {
      gridApi,
      columnDefs,
      defaultColDef,
      autoGroupColumnDef,
      getRowId,
      asyncTransactionWaitMillis,
      rowModelType,
      rowData,
      onGridReady,
      startUpdates,
      stopUpdates,
    };
  },
});

const app = createApp(VueExample);
app.mount("#app");

Showcase Example Copy Link

The following demonstrates a more complex example of transactions, it shows subscribing to a source of updates to provide the changes, while using dynamic row grouping, aggregation, and child counts. All of which react to the changes caused by the transactions.

In the example below, note the following:

After starting the updates, 2 rows are created, 5 rows are updated, and 2 rows are deleted once every second.
Groups are created or destroyed when necessary by using transactions.
The group panel has been enabled, allowing a dynamic configuration of groups.
The group child counts and aggregations update in sync with changes to the leaf rows.

main.ts

import {
  createApp,
  defineComponent,
  onBeforeMount,
  ref,
  shallowRef,
} from "vue";
import { AgGridVue } from "ag-grid-vue3";
import "./styles.css";
import {
  AutoGroupColumnDef,
  ColDef,
  ColGroupDef,
  ColumnApiModule,
  ColumnRowGroupChangedEvent,
  GetChildCount,
  GetRowIdFunc,
  GetRowIdParams,
  GridApi,
  GridOptions,
  GridReadyEvent,
  HighlightChangesModule,
  IServerSideGetRowsParams,
  IsServerSideGroupOpenByDefault,
  IsServerSideGroupOpenByDefaultParams,
  ModuleRegistry,
  RowModelType,
  ServerSideTransaction,
  TextFilterModule,
  enableDevValidations,
} from "ag-grid-community";
import {
  RowGroupingModule,
  RowGroupingPanelModule,
  ServerSideRowModelApiModule,
  ServerSideRowModelModule,
} from "ag-grid-enterprise";
import { getFakeServer, registerObserver } from "./fakeServer";

if (process.env.NODE_ENV !== "production") {
  // Enable extended validations only for development
  enableDevValidations();
}

ModuleRegistry.registerModules([
  TextFilterModule,
  HighlightChangesModule,
  ColumnApiModule,
  RowGroupingModule,
  ServerSideRowModelModule,
  ServerSideRowModelApiModule,
  RowGroupingPanelModule,
]);

function disable(id: string, disabled: boolean) {
  document.querySelector<HTMLInputElement>(id)!.disabled = disabled;
}

function getServerSideDatasource(server: any) {
  return {
    getRows: (params: IServerSideGetRowsParams) => {
      console.log("[Datasource] - rows requested by grid: ", params.request);
      const response = server.getData(params.request);
      // adding delay to simulate real server call
      setTimeout(() => {
        if (response.success) {
          // call the success callback
          params.success({
            rowData: response.rows,
            rowCount: response.lastRow,
          });
        } else {
          // inform the grid request failed
          params.fail();
        }
      }, 300);
    },
  };
}

const VueExample = defineComponent({
  template: `
        <div style="height: 100%">
                <div class="grid-container">
      <div>
        <button id="startUpdates" v-on:click="startUpdates()">Start Updates</button>
        <button id="stopUpdates" v-on:click="stopUpdates()">Stop Updates</button>
      </div>
      <ag-grid-vue
        style="width: 100%; height: 100%;"
        @grid-ready="onGridReady"
        :columnDefs="columnDefs"
        :defaultColDef="defaultColDef"
        :autoGroupColumnDef="autoGroupColumnDef"
        :rowGroupPanelShow="rowGroupPanelShow"
        :purgeClosedRowNodes="true"
        :rowModelType="rowModelType"
        :getChildCount="getChildCount"
        :getRowId="getRowId"
        :isServerSideGroupOpenByDefault="isServerSideGroupOpenByDefault"
        :rowData="rowData"
        @column-row-group-changed="onColumnRowGroupChanged"></ag-grid-vue>
      </div>
        </div>
    `,
  components: {
    "ag-grid-vue": AgGridVue,
  },
  setup(props) {
    const gridApi = shallowRef<GridApi | null>(null);
    const columnDefs = ref<ColDef[]>([
      { field: "tradeId" },
      {
        field: "product",
        rowGroup: true,
        enableRowGroup: true,
        hide: true,
      },
      {
        field: "portfolio",
        rowGroup: true,
        enableRowGroup: true,
        hide: true,
      },
      {
        field: "book",
        rowGroup: true,
        enableRowGroup: true,
        hide: true,
      },
      { field: "previous", aggFunc: "sum" },
      { field: "current", aggFunc: "sum" },
    ]);
    const defaultColDef = ref<ColDef>({
      flex: 1,
      minWidth: 100,
      enableCellChangeFlash: true,
    });
    const autoGroupColumnDef = ref<AutoGroupColumnDef>({
      minWidth: 220,
    });
    const rowGroupPanelShow = ref<"always" | "onlyWhenGrouping" | "never">(
      "always",
    );
    const rowModelType = ref<RowModelType>("serverSide");
    const rowData = ref<any[]>(null);

    function onColumnRowGroupChanged(event: ColumnRowGroupChangedEvent) {
      const colState = event.api.getColumnState();
      const groupedColumns = colState.filter((state) => state.rowGroup);
      groupedColumns.sort((a, b) => a.rowGroupIndex! - b.rowGroupIndex!);
      const groupedFields = groupedColumns.map((col) => col.colId);
      registerObserver({
        transactionFunc: (t: ServerSideTransaction) =>
          gridApi.value!.applyServerSideTransactionAsync(t),
        groupedFields: groupedFields.length === 0 ? undefined : groupedFields,
      });
    }
    function startUpdates() {
      getFakeServer().randomUpdates();
      disable("#startUpdates", true);
      disable("#stopUpdates", false);
    }
    function stopUpdates() {
      getFakeServer().stopUpdates();
      disable("#stopUpdates", true);
      disable("#startUpdates", false);
    }
    const onGridReady = (params: GridReadyEvent) => {
      gridApi.value = params.api;

      disable("#stopUpdates", true);
      // create datasource with a reference to the fake server
      const datasource = getServerSideDatasource(getFakeServer());
      // register the datasource with the grid
      params.api.setGridOption("serverSideDatasource", datasource);
      // register interest in data changes
      registerObserver({
        transactionFunc: (t: ServerSideTransaction) =>
          params.api.applyServerSideTransactionAsync(t),
        groupedFields: ["product", "portfolio", "book"],
      });
    };
    function getChildCount(data: any) {
      return data ? data.childCount : undefined;
    }
    function getRowId(params: GetRowIdParams) {
      let rowId = "";
      if (params.parentKeys && params.parentKeys.length) {
        rowId += params.parentKeys.join("-") + "-";
      }
      const groupCols = params.api.getRowGroupColumns();
      if (groupCols.length > params.level) {
        const thisGroupCol = groupCols[params.level];
        rowId += params.data[thisGroupCol.getColDef().field!] + "-";
      }
      if (params.data.tradeId != null) {
        rowId += params.data.tradeId;
      }
      return rowId;
    }
    function isServerSideGroupOpenByDefault(
      params: IsServerSideGroupOpenByDefaultParams,
    ) {
      const route = params.rowNode.getRoute();
      if (!route) {
        return false;
      }
      const routeAsString = route.join(",");
      return (
        ["Wool", "Wool,Aggressive", "Wool,Aggressive,GL-62502"].indexOf(
          routeAsString,
        ) >= 0
      );
    }

    return {
      gridApi,
      columnDefs,
      defaultColDef,
      autoGroupColumnDef,
      rowGroupPanelShow,
      rowModelType,
      getChildCount,
      getRowId,
      isServerSideGroupOpenByDefault,
      rowData,
      onGridReady,
      onColumnRowGroupChanged,
      startUpdates,
      stopUpdates,
    };
  },
});

const app = createApp(VueExample);
app.mount("#app");

Tree Data Copy Link

Transactions are also supported when using tree data. See this documented on the SSRM Tree Data page.

Getting Started

AI Features

Layout & Styling

Charting

Core Features

Advanced Features

Vue Data GridSSRM Transactions

Transaction API Copy Link

Row Grouping Copy Link

Asynchronous Updates Copy Link

Showcase Example Copy Link

Tree Data Copy Link