Lightning datatable displaying rows but values are not visible

auradatadynamic-soqllightning-datatable

I am trying to display Account records through dynamic SOQL, and I am getting the queried data in the console. Also, the result screen is displaying the rows with respect to that data, but the values in it aren't visible.

I am attaching the screenshot of the result screen, and I am adding my code below for reference. Can anyone please let me know what's wrong here?

App

<aura:application extends='force:slds'>
    <c:RakitaCompNineteen/>
</aura:application>

Component

<aura:component controller='RakitaCompNineteenMain'>
    <aura:attribute name='searchText' type='String' />
    <aura:attribute name='accounts' type='Account[]'/>
    <aura:attribute name='fields' type='List' default='["Name", "Industry", "Phone"]'/>
    <aura:attribute name='flag' type='Boolean'/>
    <lightning:card>
        <aura:set attribute='title'>
            <ui:inputText value='{!v.searchText}'/>
            <ui:button label='Search' press='{!c.invoke}'/>
        </aura:set>
        <aura:if isTrue='{!v.flag}'>
            <lightning:datatable keyField="id" data="{! v.accounts }" columns="{! v.fields }" />    
        </aura:if>
    </lightning:card>
</aura:component>

Controller

({
    invoke : function(component, event, helper) {
        var searchText = component.get('v.searchText');
        var abc = component.get('c.returnAccounts');
        abc.setParams({'searchStr':searchText});
        abc.setCallback(this, function(response){
            var state = response.getState();
            if(state === 'SUCCESS') {
                var returnVal = response.getReturnValue();
                component.set('v.accounts', returnVal);
            }
            component.set('v.flag', true);
            console.log(returnVal);
        });
        $A.enqueueAction(abc);
    }
})

Apex Class

public class RakitaCompNineteenMain {
    @AuraEnabled
    public static List<Account> returnAccounts(String searchStr) {
        String query = 'SELECT Id, Name, Industry, Phone From Account WHERE Name LIKE \'%' + searchStr + '%\'';
        List<Account> accts = Database.query(query);
        return accts;
    }
}

Screenshot of the result screen

Best Answer

Fields value which is passed columns attribute of data table could be the problem. Try creating your fields like below (label, fieldname and type). fieldname in lowercase.

Related Solutions

[SalesForce] Lightning Datatable not displaying data or headers

Two small discrepancies that I see when compared to the lightning:datatable examples:

In the lightning:datatable attribute keyField, you have a lowercase id whereas the data you're producing had and uppercase Id first letter.
In the aura:attribute name="data", the linked example has the type="Object" rather than your code which shows it as a List type.
columns is supposed to be a List type. You have it set right now as Object

[SalesForce] Lightning Datatable – Hide actions for specific rows

I have just tested it. it works fine for me. I have used the cellAttributes property to assign a css class to each cell of the action column:

Here is the code:

HTML

<template>
    <lightning-datatable key-field="id" data={addresses} columns={columns} hide-checkbox-column="true">
    </lightning-datatable>
</template>

import { LightningElement, track } from 'lwc';
import  { loadStyle } from 'lightning/platformResourceLoader';
import cssResource from '@salesforce/resourceUrl/CssFile';

const actions = [
    { label: 'Edit', name: 'edit' },
    { label: 'Delete', name: 'delete' },
];

export default class HideAction extends LightningElement {

    @track addresses = [
                        {Id:1, name: 'Accedo-10001681', email: 'test@gmail.com', apiName: 'Account', cssClass: 'showActionButton'},
                        {Id:2, name: 'A Call To Action Medi..', email: 'test@gmail.com', apiName: 'Account', cssClass: 'showActionButton'},
                        {Id:3, name: 'Adam Baxter', email: 'adam.baxter@gmail.com', apiName: 'Contact', cssClass: 'hideActionButton'},
                        {Id:4, name: 'Adam Aigner-Treworgy', email: 'adamat@gmail.com', apiName: 'Contact', cssClass: 'hideActionButton'}                 
                      ];

    actions = [
                { label: 'Edit', name: 'edit' },
                { label: 'Delete', name: 'delete' },
              ];

    @track columns = [
        { label: 'Actions', type: 'action', typeAttributes: { rowActions: actions , menuAlignment: 'left'}, cellAttributes: { class: { fieldName: 'cssClass' }}},
        { label: 'Name', fieldName: 'name', type: 'text'},
        { label: 'Api Name', type: 'button', typeAttributes: { label:  {fieldName: 'apiName'}, variant: 'base' } },
        { label: 'Email', fieldName: 'email', type: 'email' },
    ];

    connectedCallback(){
        loadStyle(this, cssResource);
    }


}

and add the string property cssClass in your wrapper class. You can use hideActionButton and showActionButton as values of the cssClass property.

Finally, you have to create a css file as a static resource otherwise it will not work. Put into the css static resource this code bellow to hide the action button:

.hideActionButton{
    opacity: 0; 
}

Here is the output:

Here is a link showing how to override css of standard lwc components

Hope this helps

Best Answer

Related Solutions

[SalesForce] Lightning Datatable not displaying data or headers

[SalesForce] Lightning Datatable – Hide actions for specific rows

Related Topic