make search in datatable records lwc code example

Example 1: lwc datatable with search

import { LightningElement, wire, api, track} from 'lwc';import { refreshApex } from '@salesforce/apex';import getOpps from '@salesforce/apex/OpportunityController.getOpps';const columns = [{        label: 'Name',        fieldName: 'Name',        type: 'text',        sortable: true    },    {        label: 'Stage',        fieldName: 'StageName',        sortable: true    },    {        label: 'Close Date',        fieldName: 'CloseDate',        sortable: true    }];export default class LightningDatatableExample extends LightningElement {    @track value;    @track error;    @track data;    @api sortedDirection = 'asc';    @api sortedBy = 'Name';    @api searchKey = '';    result;        @track page = 1;     @track items = [];     @track data = [];     @track columns;     @track startingRecord = 1;    @track endingRecord = 0;     @track pageSize = 5;     @track totalRecountCount = 0;    @track totalPage = 0;      @wire(getOpps, {searchKey: '$searchKey', sortBy: '$sortedBy', sortDirection: '$sortedDirection'})    wiredAccounts({ error, data }) {        if (data) {                    this.items = data;            this.totalRecountCount = data.length;             this.totalPage = Math.ceil(this.totalRecountCount / this.pageSize);                         this.data = this.items.slice(0,this.pageSize);             this.endingRecord = this.pageSize;            this.columns = columns;            this.error = undefined;        } else if (error) {            this.error = error;            this.data = undefined;        }    }    //clicking on previous button this method will be called    previousHandler() {        if (this.page > 1) {            this.page = this.page - 1; //decrease page by 1            this.displayRecordPerPage(this.page);        }    }    //clicking on next button this method will be called    nextHandler() {        if((this.page<this.totalPage) && this.page !== this.totalPage){            this.page = this.page + 1; //increase page by 1            this.displayRecordPerPage(this.page);                    }                 }    //this method displays records page by page    displayRecordPerPage(page){        this.startingRecord = ((page -1) * this.pageSize) ;        this.endingRecord = (this.pageSize * page);        this.endingRecord = (this.endingRecord > this.totalRecountCount)                             ? this.totalRecountCount : this.endingRecord;         this.data = this.items.slice(this.startingRecord, this.endingRecord);        this.startingRecord = this.startingRecord + 1;    }            sortColumns( event ) {        this.sortedBy = event.detail.fieldName;        this.sortedDirection = event.detail.sortDirection;        return refreshApex(this.result);            }      handleKeyChange( event ) {        this.searchKey = event.target.value;        return refreshApex(this.result);    }}

Example 2: lightning datatable with search lwc

<template>    <lightning-card title="Lightning Datatable Example">        <div class="slds-m-around_medium">            <lightning-input type="search" onchange={handleKeyChange} class="slds-m-bottom_small" label="Search"                value={searchKey}></lightning-input>            <lightning-datatable key-field="Id" data={data} columns={columns} sorted-by={sortedBy}                sorted-direction={sortedDirection} onsort={sortColumns}>            </lightning-datatable>            </br>            <lightning-layout horizontal-align="space">                <lightning-layout-item flexibility="auto">                    <lightning-button label="Previous" icon-name="utility:chevronleft" onclick={previousHandler}>                    </lightning-button>                </lightning-layout-item>                <lightning-layout-item flexibility="auto">                    Page {page} of {totalPage}                </lightning-layout-item>                <lightning-layout-item flexibility="auto">                    <lightning-button label="Next" icon-name="utility:chevronright" icon-position="right"                        onclick={nextHandler}></lightning-button>                </lightning-layout-item>            </lightning-layout>        </div>    </lightning-card></template>

Tags:

Misc Example