[SalesForce] How to show name of custom object in lightning component datatable

I have a Engagement object with a custom field Account__c that has Name field. I want to show the name of the Account, but currently it shows the Id. How can I show the Account__c.Name rather than Id?

Apex Class Code:

public class EngagedAccountController {
    @AuraEnabled
    public static List<Engagement__c> getEngagedAccounts(Id oppId) {
        Volunteer_Opportunity__c opp = [Select Name, Support_Required__c FROM Volunteer_Opportunity__c WHERE id = :oppId];
        List<Engagement__c> engagedAccounts = [Select Name, Account__c FROM Engagement__c WHERE Volunteer_Opportunity__c = :opp.Id];
        return engagedAccounts;
    } 
}

Lightning Component Javascript:

({
    myAction : function(component, event, helper) {

        component.set("v.Columns", [
            {label:"Name", fieldName:"Name", type:"text"},
            {label:"Account", fieldName:"Account__c", type:"text"}
        ]);

        var action_get_engaged_accounts = component.get("c.getEngagedAccounts");
        action_get_engaged_accounts.setParams({
            oppId: component.get("v.recordId")
        });

        action_get_engaged_accounts.setCallback(this, function(data) {
            component.set("v.accounts", data.getReturnValue());
        });

        $A.enqueueAction(action_get_engaged_accounts); 
    }
})

Lightning Component Component:

<aura:component controller="EngagedAccountController" implements="flexipage:availableForRecordHome,force:hasRecordId" access="global" >

    <aura:attribute name="recordId" type="Id" />
    <aura:attribute name="opportunity" type="Volunteer_Opportunity__c" />
    <aura:attribute name="accounts" type="Engagement__c" />
    <aura:attribute name="Columns" type="List" />

    <aura:handler name="init" value="{!this}" action="{!c.myAction}" />

    <force:recordData aura:id="accountRecord"
                      recordId="{!v.recordId}"
                      targetFields="{!v.opportunity}"
                      layoutType="FULL"
                      />

    <lightning:card iconName="standard:entitlement" title="{! 'Accounts engaged in this opportunity'}">
        <lightning:datatable data="{!v.accounts}" keyField="id" columns="{! v.Columns }" hideCheckboxColumn="true"/> 
    </lightning:card>

</aura:component>

How it looks currently:

Best Answer

AFAIK the fieldName attribute of lightning:dataTable does not support dotted expressions that cross object boundaries such as Account__r.Name.

So the simplest fix is to add a formula field called "Account Name" of Account__r.Name to your Engagement__c object and query and reference that in the table.

Or use this technique.

Related Solutions

[SalesForce] Lightning Component for specific Custom Object

You can use Page Manager and build your own page in Napili Template .

You can pull of the Standard Detail Page components and your custom components there and expose that as a Tab .

[SalesForce] How to use custom LWC lightning component in lightning-datatable

Step 1 : create custom component as follows.

pocCustomComp.html :

<template>
    <div>
        Id: {recordId}
    </div>
    <lightning-file-upload label="Upload"
                           name="fileUploader"
                           accept={acceptedFormats}
                           record-id={recordId}
                           onuploadfinished={handleUploadFinished}>
    </lightning-file-upload>
</template>

and its JS:

import { LightningElement, api } from 'lwc';
import { ShowToastEvent } from 'lightning/platformShowToastEvent';

export default class PocCustomComp extends LightningElement {
    @api recordId;
    @api acceptedFormats;
    handleUploadFinished() {
        this.dispatchEvent(new CustomEvent('uploadfinished', {
            composed: true,
            bubbles: true,
            cancelable: true,
            detail: {
                data: { name: 'some data', recordId: this.recordId }
            }
        }));
        this.dispatchEvent(new ShowToastEvent({
            title: 'Completed',
            message: 'File has been uploaded',
        }));
    }
}

Step 2 : Create a new component which extends datatable

pocLightningDatatable.js:

import LightningDatatable from 'lightning/datatable';
import pocFileUpload from './pocFileUpload.html';

export default class PocLightningDatatable extends LightningDatatable {
    static customTypes = {
        fileUpload: {
            template: pocFileUpload,
            typeAttributes: ['acceptedFormats'],
        }
    };
}

Here we are defining custom data types – fileUpload. Also do you notice that we are importing pocFileUpload template? You need to create pocFileUpload.html in the same folder as pocLightningDatatable

pocFileUpload.html – you have to use the custom component that we created before.

<template>
    <c-poc-custom-comp record-id={value}
                       accepted-formats={typeAttributes.acceptedFormats}>
    </c-poc-custom-comp>
</template>

Observe the usage of value here, it is automatically passed as the value for the fieldName we define in columns.

Step 3 : We can use the component (that extended datatable) where-ever we want

<template>
    <c-poc-lightning-datatable key-field="id"
                data={data}
                columns={columns}
                onuploadfinished={handleUploadFinished}
                hide-checkbox-column>
    </c-poc-lightning-datatable>
</template>

And the javascript which uses custom datatype:

import { LightningElement, track } from 'lwc';
import findAccounts from '@salesforce/apex/poc.findAccounts';

export default class Poc extends LightningElement {
    @track data = [];
    connectedCallback() {
        this.columns = [
            { label: 'Name', fieldName: 'Name' },
            { label: 'Account Number', fieldName: 'AccountNumber' },
            { label: 'Upload', type: 'fileUpload', fieldName: 'Id', typeAttributes: { acceptedFormats: '.jpg,.jpeg,.pdf,.png' } }
        ];
        findAccounts().then(res => { this.data = res; }).catch(err => console.error(err));
    }
    handleUploadFinished(event) {
        event.stopPropagation();
        console.log('data => ', JSON.stringify(event.detail.data));
    }
}

Note: pocLightningDatatable.html will not have anything in it.

Apex class:

public without sharing class poc {

    @AuraEnabled(cacheable=true)
    public static List<Account> findAccounts() {
        return [SELECT Name, AccountNumber from Account Limit 10];
    }

}

Reference: https://salesforcesas.home.blog/2019/07/26/using-custom-lwc-components-in-lightning-datatable/

Best Answer

Related Solutions

[SalesForce] Lightning Component for specific Custom Object

[SalesForce] How to use custom LWC lightning component in lightning-datatable

Related Topic