public with sharing class LightningDataTable {

    public static list<providerEntity__c> getProviderList(string searchKey,string ProviderId) {
        string sTempSearchKey = '%' + searchKey + '%';

        // create contact list to store search result 
        list<providerEntity__c> lstContact = new list<providerEntity__c>();

        // query contact records
        for(providerEntity__c oCon : [Select Id, Name, Provider_Name_API__c, NPI__c, FedId__c, LicenceId__c, MedicareOscarNumber__c, (select Name, Site__c,  SLName__c,ProviderIdTxt__c,LOBName__c,PayToContractName__c from Service_Affiliation1__r )  From providerEntity__c WHERE (Provider_Name_API__c LIKE : sTempSearchKey OR NPI__c LIKE: sTempSearchKey  OR FedId__c LIKE: sTempSearchKey ) ]){

        //If there are no records found with searchKey then, throw aura exception with a message
        if(lstContact.size() == 0){
            throw new AuraHandledException('No Record Found..'); 

        return lstContact;



    <lightning-card title = "Search " icon-name = "custom:custom63">  
        <div class = "slds-m-around_medium">  
            <lightning-input type = "search" onchange = {handleKeyChange} class = "slds-m-bottom_small" label = "Search" >
            <template if:true = {providers}>

                <div style="height: 300px;">  
                    <lightning-datatable key-field="Id"
            <template if:true = {error}>  


import { LightningElement,track,api, wire } from 'lwc';
import getProviderList from '@salesforce/apex/LightningDataTable.getProviderList';
// import standard toast event 
import {ShowToastEvent} from 'lightning/platformShowToastEvent'; 
import { NavigationMixin } from 'lightning/navigation';
const columns = [
    {label: 'Name',fieldname: 'Provider_Name_API__c',type: 'Text;},
    {label: 'Id',fieldname: 'ServiceAffiliation1Name',type: 'Text'}, 
    {label: 'NPI',fieldname: 'NPI__c',type: 'Text'},
    {label: 'TIN',fieldname: 'FedId__c',type: 'Text'},
    {label: 'Site Id',fieldname: 'ServiceAffiliation1Site',type: 'Text'},
    {label: 'PPG',fieldname: 'ServiceAffiliation1SLName',type: 'Text'},
    {label: 'Address',fieldname: 'ServiceAffiliation1ProviderIdTxt',type: 'Text'},
    {label: 'LOB',fieldname: 'ServiceAffiliation1LOBName',type: 'Text'},
    {label: 'Contract Name',fieldname: 'ServiceAffiliation1PayToContractName',type: 'Text'},
    {label: 'License Id',fieldname: 'LicenceId__c',type: 'Text'},
    {label: 'Medicare Oscar Number',fieldname: 'MedicareOscarNumber__c',type: 'Text'}

export default class ProviderLightningTable extends  NavigationMixin(LightningElement) {
    @api recordId;
    @track providers; 
    @track error; 
    @track columns = columns; 
    searchKey = '';
    @wire(getProviderList, {
        searchKey: '$searchKey',
        ProviderId: 'recordId'
        this.wiredActivities = value;
        const { data, error } = value;

        if (data) { 
            var ObjData = JSON.parse(JSON.stringify(data));

            ObjData.forEach(Record => {

                Record.ServiceAffiliation1Name =  Record.Service_Affiliation1__r.Name != undefined ? Record.Service_Affiliation1__r.Name : '';
                Record.ServiceAffiliation1Site =  Record.Service_Affiliation1__r.Site__c != undefined ? Record.Service_Affiliation1__r.Site__c : '';
                Record.ServiceAffiliation1SLName =  Record.Service_Affiliation1__r.SLName__c != undefined ? Record.Service_Affiliation1__r.SLName__c: '';
                Record.ServiceAffiliation1ProviderIdTxt =  Record.Service_Affiliation1__r.ProviderIdTxt__c != undefined ? Record.Service_Affiliation1__r.ProviderIdTxt__c: '';
                Record.ServiceAffiliation1LOBName =  Record.Service_Affiliation1__r.LOBName__c != undefined ? Record.Service_Affiliation1__r.LOBName__c: '';
                Record.ServiceAffiliation1PayToContractName =  Record.Service_Affiliation1__r.PayToContractName__c != undefined ? Record.Service_Affiliation1__r.PayToContractName__c: '';


            this.providers = ObjData;
            this.error = undefined;
        } else if (error) {  
            this.error = error;  
            this.providers = undefined;

    handleKeyChange( event ) {
        this.searchKey = event.target.value;

Record.Service_Affiliation1__r is a list, so in order to access to its elements you have to use brackets notation, i.e. Record.Service_Affiliation1__r[0].Name.
So if you only need the info of the first child, you can change your forEach to:

ObjData.forEach((record) => {
    if (record.Service_Affiliation__r && record.Service_Affiliation__r.length) {
        record.ServiceAffiliation1Name =  record.Service_Affiliation__r[0].Name;
        record.ServiceAffiliation1Site =  record.Service_Affiliation__r[0].Site__c;
        record.ServiceAffiliation1SLName =  record.Service_Affiliation__r[0].SLName__c;
        record.ServiceAffiliation1ProviderIdTxt =  record.Service_Affiliation__r[0].ProviderIdTxt__c;
        record.ServiceAffiliation1LOBName =  record.Service_Affiliation__r[0].LOBName__c;
        record.ServiceAffiliation1PayToContractName =  record.Service_Affiliation__r[0].PayToContractName__c;

Keep in mind that A single providerEntity__c record may have multiple children, therefore Service_Affiliation1__r may have more than one element and if you have to show hierarchical data in a table, you might want to give a look at Tree Grid component.

  • @SattiRenukaSravanthi In JS the if should be if (record.Service_Affiliation1__r && record.Service_Affiliation1__r.length) {. About where assinging providerId in apex, you should update your question explaining what is the goal of that method: would you get from that query and what is the requirement.
    – RubenDG
    Sep 26 '21 at 12:46
  • Providerentity__c is parent, serviceaffiliation__c is child,service_affiliation1__c is childrelationship name..iwant tosearch parent obj fields on search bar where I need to display data of both parent and child in datatable. Providerid__c is the lookup field on child. Is there any need to assign providerid(ProviderId: 'recordId') in the apex.if yes where and to what..Thanks
    – Renuka
    Sep 26 '21 at 15:05
  • @SattiRenukaSravanthi please post the output of console.log(JSON.stringify(ObjData));. About providerId you need to use it if you want to fetch only records that are children of the specific Providerentity__c. If so, replace the whole WHERE clause with WHERE Id = :ProviderId
    – RubenDG
    Sep 26 '21 at 19:52
  • Objdata Proxy {} providerLightningTable.js:4 [{"Id":"a1Q0m000001uiuREAQ","Name":"984874","Provider_Name_API__c":"Grace","NPI__c":"9876543211","FedId__c":"123456","LicenceId__c":"87654","MedicareOscarNumber__c":"12345","Service_Affiliation__r":[{"ProviderId__c":"a1Q0m000001uiuREAQ","Id":"a1R0m000000KteZEAS","Name":"SA-1732680","LOBName__c":"tres"}],"ServiceAffiliation1Name":"SA-1732680","ServiceAffiliation1LOBName":"tres"}]
    – Renuka
    Sep 27 '21 at 5:00
  • @SattiRenukaSravanthi I updated the forEach, try it now.
    – RubenDG
    Sep 27 '21 at 7:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.