Can we use Accordion Feature in Lightning-datatable LWC

Question

Can we use accordion feature in Lightning-Datatable LWC ? or Any other way to achieve same functionality in Lightning-Datatable LWC?

We have already built Lightining-datatable and using all its features such as column sorting, column header actions, row actions. Now the requirement is we need show child record using accordion feature.

As far as i know, we do have tree feature, or we can use accordion feature, but we can not use them with Lightning-datatable. We can use custom HTML table with slds tags as alternative to achieve, but in our case we already developed Lightning-datatable and using its features such column header action, row action, sorting etc.

Can someone suggest any alternative to achieve accordion in Lightning-datatable LWC.

Answer 1

On the assumption I've understood your question correctly, we have done this as follows:

1. Extend the data table to support a custom cell data type:

import LightningDatatable from 'lightning/datatable';
import matchCell from './exampleMatchCell.html';

/**
 * Extends the lightning-datatable component to add a custom matchScore cell type.
 * This custom cell uses a lightning-accordion to show a single collapsible section with an icon.
 */
export default class ExampleResultsTable extends LightningDatatable {
    static customTypes = {
        matchScore: {
            template: matchCell
        }
    }
}

2. Provide the custom cell rendering (exampleMatchCell.html):

<template>
    <lightning-accordion allow-multiple-sections-open>
        <lightning-accordion-section name="breakdown" label={value.percentage}>
            <lightning-icon slot="actions" icon-name={value.icon} variant={value.iconVariant}></lightning-icon>
            <template for:each={value.notes} for:item="note">
                <p class="slds-truncate" title={note.value} key={note.key}>{note.value}</p>
            </template>
        </lightning-accordion-section>
    </lightning-accordion>
</template>

3. Use this custom component in the parent rendering instead of the standard data table:

        ...
        <c-example-results-table
                key-field="Id"
                data={_results}
                columns={_columns}
                onrowaction={handleRowActions}
                hide-checkbox-column>
        </c-example-results-table>

4. Have the parent define the columns including the custom type:

            ...
            this._columns.push({
                fieldName: 'score',
                label: this.Label.ColumnMatch,
                type: 'matchScore',
                initialWidth: 250,
                fixedWidth: undefined,
                typeAttributes: {}
            });
            ...

For us, our datatable gets rendered like the following example, where the "Match" column is the one containing an accordion:

The row height adjusts depending on whether the accordion is open or closed, as illustrated.

You will find documentation about handling columns with "custom data types" under "Creating Custom Data Types".