Expanding Sub-Rows/Tree Data Feature Guide

Expanding Sub-Rows (Tree Data) Feature Guide

Material React Table has support for expanding sub-rows or tree data. This feature is useful for displaying hierarchical data. The sub-rows can be expanded and collapsed by clicking on the expand/collapse icon.

NOTE: This feature is for expanding rows of the same data type. If you want to add expansion of more data for the same row, check out the Detail Panel Feature Guide.

Relevant Props

#	Type	Default Value	More Info Links
1	Array<TData>		Usage Docs

2	boolean		TanStack Table Expanding Docs

3	boolean	true	MRT Expanding Sub Rows Docs

4	boolean		MRT Expanding Sub Rows Docs

5	(dataRow: TData) => TData[]

6	boolean	false	TanStack Filtering Docs

7	() => MRT_RowModel<TData>

8	(row: Row<TData>) => boolean		TanStack Table Expanding Docs

9	(row: Row<TData>) => boolean		TanStack Table Expanding Docs

10	(originalRow: TData, index: number) => undefined \| TData[]		TanStack Table Core Table Docs

11	boolean		TanStack Table Expanding Docs

12	number	100	TanStack Table Filtering Docs

13	IconButtonProps \| ({ table }) => IconButtonProps		Material UI IconButton Props

14	IconButtonProps \| ({ row, table }) => IconButtonProps		Material UI IconButton Props

15	OnChangeFn<ExpandedState>		TanStack Table Expanding Docs

16	boolean		TanStack Table Expanding Docs

17	'first' \| 'last'

Relevant State Options

	#	State Option	Type	Default Value	More Info Links
	1		Record<string, boolean> \| boolean	{}	TanStack Table Expanding Docs

Enable Expanding Sub-Rows

To enable expanding sub-rows, you must first set the enableExpanding prop to true.

However, your data must also be formatted in a way to allow for expanding rows that are in some way related to each other. By default, Material React Table will look for a special subRows property on each row of your data, and treat any array of rows that it finds as the sub-rows for that row. You can customize and override this behavior by passing a custom getSubRows prop.

const data = [
  {
    id: 1,
    name: 'John Doe',
    subRows: [
      {
        id: 2,
        name: 'Jane Doe',
      },
    ],
  },
];

return (
  <MaterialReactTable
    columns={columns}
    data={data}
    enableExpanding
    getSubRows={(originalRow) => originalRow.subRows} //default, can customize
  />
);

Demo

Open Stackblitz Open Code Sandbox Open on GitHub

	First Name	Last Name	Address	City	State
	Dylan	Murray	261 Erdman Ford	East Daphne	Kentucky
	Raquel	Kohler	769 Dominic Grove	Columbus	Ohio

Source Code

1import React, { FC, useMemo } from 'react';
2import MaterialReactTable from 'material-react-table';
3
4export const data = [
5  {
6    firstName: 'Dylan',
7    lastName: 'Murray',
8    address: '261 Erdman Ford',
9    city: 'East Daphne',
10    state: 'Kentucky',
11    subRows: [
12      {
13        firstName: 'Ervin',
14        lastName: 'Reinger',
15        address: '566 Brakus Inlet',
16        city: 'South Linda',
17        state: 'West Virginia',
18        subRows: [
19          {
20            firstName: 'Jordane',
21            lastName: 'Homenick',
22            address: '1234 Brakus Inlet',
23            city: 'South Linda',
24            state: 'West Virginia',
25          },
26        ],
27      },
28      {
29        firstName: 'Brittany',
30        lastName: 'McCullough',
31        address: '722 Emie Stream',
32        city: 'Lincoln',
33        state: 'Nebraska',
34      },
35    ],
36  },
37  {
38    firstName: 'Raquel',
39    lastName: 'Kohler',
40    address: '769 Dominic Grove',
41    city: 'Columbus',
42    state: 'Ohio',
43    subRows: [
44      {
45        firstName: 'Branson',
46        lastName: 'Frami',
47        address: '32188 Larkin Turnpike',
48        city: 'Charleston',
49        state: 'South Carolina',
50      },
51    ],
52  },
53];
54
55const Example = () => {
56  const columns = useMemo(
57    //column definitions...
58    () => [
59      {
60        accessorKey: 'firstName',
61        header: 'First Name',
62      },
63      {
64        accessorKey: 'lastName',
65        header: 'Last Name',
66      },
67
68      {
69        accessorKey: 'address',
70        header: 'Address',
71      },
72      {
73        accessorKey: 'city',
74        header: 'City',
75      },
76
77      {
78        accessorKey: 'state',
79        enableColumnOrdering: false,
80        header: 'State',
81      },
82    ],
83    [],
84    
85  );
86
87  return (
88    <MaterialReactTable
89      columns={columns}
90      data={data}
91      enableExpanding
92      enableExpandAll //default
93    />
94  );
95};
96
97export default Example;
98

Expand All Rows Button

By default, Material React Table will show the expand all button in the expand column header. You can disable this by setting the enableExpandAll prop to false.

<MaterialReactTable
  columns={columns}
  data={data}
  enableExpanding
  enableExpandAll={false} //hide expand all button in header
/>

Expanded Rows Pagination Behavior

By default, Material React Table will treat expanded sub-rows the same as any other row when it comes to pagination. This means that some expanded rows may be on the next page. You can change this behavior by setting the paginateExpandedRows prop to false.

<MaterialReactTable
  columns={columns}
  data={data}
  enableExpanding
  paginateExpandedRows={false} //expanded rows will be on the same page as their parent row
/>

Expanded Leaf Row Filtering Behavior

If you are using the filtering features along-side sub-row features, then there are a few behaviors and customizations you should be aware of.

Filter From Leaf Rows

By default, filtering is done from parent rows down (so if a parent row is filtered out, all of its children will be filtered out as well). Setting the filterFromLeafRows prop to true will cause filtering to be done from leaf rows up (which means parent rows will be kept so long as one of their child, or grand-child, etc. rows pass the filtering).

<MaterialReactTable
  columns={columns}
  data={data}
  enableExpanding
  filterFromLeafRows //search for child rows and preserve parent rows
/>

Max Leaf Row Filter Depth

New in v1.3.11 from TanStack Table v8.6.0 and later!

By default, filtering is done for all rows (max depth of 100), no matter if they are root level parent rows or the child leaf rows of a parent row. Setting the maxLeafRowFilterDepth prop to 0 will cause filtering to only be applied to the root level parent rows, with all sub-rows remaining unfiltered. Similarly, setting this option to 1 will cause filtering to only be applied to child leaf rows 1 level deep, and so on.

This is useful for situations where you want a row's entire child hierarchy to be visible regardless of the applied filter.

<MaterialReactTable
  columns={columns}
  data={data}
  enableExpanding
  maxLeafRowFilterDepth={0} //When filtering root rows, keep all child rows of the passing parent rows
/>

Expand All Rows By Default

You can manage the initial state of the expanded rows with the expanded state option in either the initialState or state props.

For example, you may want all rows to be expanded by default. You can simply set the expanded state option to true to do this.

<MaterialReactTable
  columns={columns}
  data={data}
  enableExpanding
  initialState={{ expanded: true }} //all rows expanded by default
/>

Demo

Open Stackblitz Open Code Sandbox Open on GitHub

First Name	Last Name	Address	City	State
Dylan	Murray	261 Erdman Ford	East Daphne	Kentucky
Ervin	Reinger	566 Brakus Inlet	South Linda	West Virginia
Jordane	Homenick	1234 Brakus Inlet	South Linda	West Virginia
Jordan	Clarkson	4882 Palm Rd	San Francisco	California
Brittany	McCullough	722 Emie Stream	Lincoln	Nebraska
Raquel	Kohler	769 Dominic Grove	Columbus	Ohio
Branson	Frami	32188 Larkin Turnpike	Charleston	South Carolina

Source Code

1import React, { FC, useMemo } from 'react';
2import MaterialReactTable, { MRT_ColumnDef } from 'material-react-table';
3
4export type Person = {
5  firstName: string;
6  lastName: string;
7  address: string;
8  city: string;
9  state: string;
10  subRows?: Person[]; //Each person can have sub rows of more people
11};
12
13export const data: Person[] = [
14  {
15    firstName: 'Dylan',
16    lastName: 'Murray',
17    address: '261 Erdman Ford',
18    city: 'East Daphne',
19    state: 'Kentucky',
20    subRows: [
21      {
22        firstName: 'Ervin',
23        lastName: 'Reinger',
24        address: '566 Brakus Inlet',
25        city: 'South Linda',
26        state: 'West Virginia',
27        subRows: [
28          {
29            firstName: 'Jordane',
30            lastName: 'Homenick',
31            address: '1234 Brakus Inlet',
32            city: 'South Linda',
33            state: 'West Virginia',
34          },
35          {
36            firstName: 'Jordan',
37            lastName: 'Clarkson',
38            address: '4882 Palm Rd',
39            city: 'San Francisco',
40            state: 'California',
41          },
42        ],
43      },
44      {
45        firstName: 'Brittany',
46        lastName: 'McCullough',
47        address: '722 Emie Stream',
48        city: 'Lincoln',
49        state: 'Nebraska',
50      },
51    ],
52  },
53  {
54    firstName: 'Raquel',
55    lastName: 'Kohler',
56    address: '769 Dominic Grove',
57    city: 'Columbus',
58    state: 'Ohio',
59    subRows: [
60      {
61        firstName: 'Branson',
62        lastName: 'Frami',
63        address: '32188 Larkin Turnpike',
64        city: 'Charleston',
65        state: 'South Carolina',
66      },
67    ],
68  },
69];
70
71const Example: FC = () => {
72  const columns = useMemo<MRT_ColumnDef<Person>[]>(
73    //column definitions...
74    () => [
75      {
76        accessorKey: 'firstName',
77        header: 'First Name',
78      },
79      {
80        accessorKey: 'lastName',
81        header: 'Last Name',
82      },
83
84      {
85        accessorKey: 'address',
86        header: 'Address',
87      },
88      {
89        accessorKey: 'city',
90        header: 'City',
91      },
92
93      {
94        accessorKey: 'state',
95        enableColumnOrdering: false,
96        header: 'State',
97      },
98    ],
99    [],
100    
101  );
102
103  return (
104    <MaterialReactTable
105      columns={columns}
106      data={data}
107      enableExpandAll={false} //hide expand all double arrow in column header
108      enableExpanding
109      filterFromLeafRows //apply filtering to all rows instead of just parent rows
110      initialState={{ expanded: true }} //expand all rows by default
111      paginateExpandedRows={false} //When rows are expanded, do not count sub-rows as number of rows on the page towards pagination
112    />
113  );
114};
115
116export default Example;
117