Hello Trailblazers,
In this blog post, we will learn how to handle Row-Level actions in Lightning Datatable in Lightning Web Component (LWC).
Acceptance Criteria: Create a lightning datatable that will display all the product details. The product details component should have 2-Row Level actions.
- Show Details – When the user clicks on the button, it should take the user to the product details page (record page).
- Delete – When the user clicks on the button, it should delete the product from the database.
Row Level Action in Datatable in LWC:
RowLevelAction.Controller
public class ProductClass {
@AuraEnabled(cacheable = true)
public static List<Product2> getProductDetails(){
List<Product2> prodList = [SELECT Name, ProductCode, Family, IsActive, Description FROM Product2];
return prodList;
}
}
RowLevelActionComp.html
<template>
<lightning-card title="Row Level Action on Product" icon-name="standard:product"> <br/>
<template if:true={data}>
<lightning-datatable key-field="Id" data={data} columns={columns} onrowaction={handleRowLevelAct}>
</lightning-datatable>
</template>
<!-- Spinner -->
<div if:true={showLoadingSpinner}>
<lightning-spinner alternative-text="Loading" size="large"></lightning-spinner>
</div>
</lightning-card>
</template>
RowLevelActionComp.js
import { LightningElement, track, wire } from 'lwc';
import PaymentDetails from '@salesforce/apex/ProductClass.getProductDetails';
import { ShowToastEvent } from 'lightning/platformShowToastEvent';
import { NavigationMixin } from 'lightning/navigation';
import { deleteRecord } from 'lightning/uiRecordApi';
//define row actions
const actions = [
{ label: 'Show Details', name: 'view' },
{ label: 'Delete', name: 'delete' }
];
const columns = [
{label: 'Product Name',fieldName: 'Name' , type: 'text', sortable: true },
{label: 'Product Code',fieldName: 'ProductCode' , type: 'text', sortable: true },
{label: 'Product Family',fieldName: 'Family' , type: 'picklist', sortable: true },
{label: 'Active',fieldName: 'IsActive' , type: 'checkbox', sortable: true },
{label: 'Description',fieldName: 'Description' , type: 'text', sortable: true },
{
type: 'action',
typeAttributes: {
rowActions: actions,
menuAlignment: 'right'
}
}
]
export default class RowLevelActionComp extends NavigationMixin (LightningElement) {
columns = columns;
@track error;
@track data;
@track showLoadingSpinner = false;
refreshTable;
//retrieving the products using wire service...
@wire(PaymentDetails)
wiredProd({error, data}){
if(data){
console.log('data is =>',data);
this.data = data;
} else if(error){
this.error = "No Products to show";
}
}
// Handle auto-number click event
handleRowLevelAct(event) {
const recordId = event.detail.row.Id
const actionName = event.detail.action.name;
switch (actionName) {
case 'view':
this[NavigationMixin.Navigate]({
type: 'standard__recordPage',
attributes: {
recordId: recordId,
objectApiName: 'Product2',
actionName: 'view'
}
});
break;
case 'delete':
this.showLoadingSpinner = true;
deleteRecord(recordId)
.then(() => {
this.showLoadingSpinner = false;
this.dispatchEvent(
new ShowToastEvent({
title : 'Success',
message : 'Your Product has been deleted successfully' ,
variant : 'success'
})
);
return refreshApex(this.refreshTable);
})
.catch(error => {
this.dispatchEvent(
new ShowToastEvent({
title : 'Error while deleting record',
message : error.body.message ,
variant : 'success'
})
);
});
break;
}
}
}
RowLevelActionComp.xml
<?xml version="1.0" encoding="UTF-8"?>
<LightningComponentBundle xmlns="http://soap.sforce.com/2006/04/metadata">
<apiVersion>58.0</apiVersion>
<isExposed>true</isExposed>
<targets>
<target>lightning__RecordPage</target>
<target>lightning__AppPage</target>
<target>lightning__HomePage</target>
</targets>
</LightningComponentBundle>
In the above example, in the controller, we retrieved all the product details from the Product object.
The retrieved data is displayed in a Lightning Datatable with columns for Product Name, Product Code, Product Family, Active, and Description respectively.
Here, deleteRecord, NavigationMixin, and ShowToastEvent are already imported according to requirements. The ‘Action’ column includes row-level actions for Show Details’, and ‘Delete’.
The handleRowLevelAct method is invoked when a row action is triggered. It checks the action name and performs the corresponding action.
Spinner in LWC:
We used a loading spinner in this Lightning Web component. As it is the best practice for improving user experience nd indicating that a process is in progress.
Output:
In this lightning datatable, when the user clicks on the down arrow on the right side, the row-level action menu will be visible.
So, when the user clicks on “Show Details”, it will redirect the user to the product detail page/record page. And, when the user clicks on “Delete”, then that particular record will get deleted from the database.
In this way, we learnt how to handle row-level actions in Lightning Datatable in Lightning Web Component (LWC).
Stay Tuned !!
References:
You can also read :
1.An Introduction to Salesforce CPQ
2.Salesforce CPQ and its Key Features
3.Unlocking the Power of AI: Einstein for Developers
4.Revolutionizing Customer Engagement: The Salesforce Einstein Chatbot
