Retrieving data from Account using @wire Decorators in Lightning web Components with apex method and lightning datatable -- LWC | how to fetch account records using @wire decorators in lwc

1,991 views

Hey guys, today in this post we are going to learn about How to Retrieving data from Account using @wire Decorators in Lightning web Components with apex method and lightning datatable

Files we used in this post example:-

wireDecoratorsDataTable.html.html	Lightning Web Component HTML	Template HTML file for used to write HTML element for user interface.
wireDecoratorsDataTable.js	Lightning Web Component JavaScript	It is hold @wire Decorators load functionality.
wireDecoratorsDataTable.js-meta.xml	XML Meta File	It is used for where this lightning web component should be exposed.
lwcAppExampleApex.cls	Apex Controller	It is used for Fetching Account records from @wire Decorators with apex method "@AuraEnabled (cacheable=true)"

Don’t forget to check out:- Calling an apex method imperatively and fetching contact record from database without @wire and create lightning data-table Click Here For More Information

Live Demo

Other related post that would you like to learn in Salesforce

Download ebooks:- Click here to download E-Book "The most 20 popular articles of w3web.net"

Step 1:- Create Lightning Web Component : wireDecoratorsDataTable.html

SFDX:Lightning Web Component >> New >> wireDecoratorsDataTable.html

wireDecoratorsDataTable.html [Lightning Web Component HTML]

  <template>
    <lightning-card>
        <h3 slot="title">
            <lightning-icon icon-name="standard:account" size="small"></lightning-icon>  @wire Decorators in Lightning web components with apex method  @AuraEnabled (cacheable=true)        
        </h3>                     
       
        <lightning-datatable data={accData} columns={columnTable} key-field="Id"></lightning-datatable>


<br/><br/>
   <!--Start RelatedTopics Section-->
<div style="border:1px #ddd solid; padding:10px; background:#eee; margin:40px 0;">
            
            <p data-aura-rendered-by="435:0"><img src="https://www.w3web.net/wp-content/uploads/2021/05/thumbsUpLike.png" width="25" height="25" style="vertical-align:top; margin-right:10px;" data-aura-rendered-by="436:0"><strong data-aura-rendered-by="437:0"><span style="font-size:16px; font-style:italic; display:inline-block; margin-right:5px;">Don't forget to check out:-</span><a href="https://www.w3web.net/" target="_blank" rel="noopener noreferrer" style="text-decoration:none;" data-aura-rendered-by="440:0">An easy way to learn step-by-step online free Salesforce tutorial, To know more Click  <span style="color:#ff8000; font-size:18px;" data-aura-rendered-by="442:0">Here..</span></a></strong></p>
 
            <br/><br/>
            <p data-aura-rendered-by="435:0"><img src="https://www.w3web.net/wp-content/uploads/2021/07/tickMarkIcon.png" width="25" height="25" style="vertical-align:top; margin-right:10px;" data-aura-rendered-by="436:0"><strong data-aura-rendered-by="437:0"><span style="font-size:17px; font-style:italic; display:inline-block; margin-right:5px; color:rgb(255 128 0);">You May Also Like →</span> </strong></p>
            <div style="display:block; overflow:hidden;"> 
                <div style="width: 50%; float:left; display:inline-block">
                    <ul style="list-style-type: square; font-size: 16px; margin: 0 0 0 54px; padding: 0;"> 
                        <li><a href="https://www.w3web.net/lwc-get-set-lightning-checkbox-value/" target="_blank" rel="noopener noreferrer">How to get selected checkbox value in lwc</a></li>
                        <li><a href="https://www.w3web.net/display-account-related-contacts-in-lwc/" target="_blank" rel="noopener noreferrer">how to display account related contacts based on AccountId in lwc</a></li>
                        <li><a href="https://www.w3web.net/create-lightning-datatable-row-actions-in-lwc/" target="_blank" rel="noopener noreferrer">how to create lightning datatable row actions in lwc</a></li>
                        <li><a href="https://www.w3web.net/if-and-else-condition-in-lwc/" target="_blank" rel="noopener noreferrer">how to use if and else condition in lwc</a></li>
                        <li><a href="https://www.w3web.net/get-selected-radio-button-value-and-checked-default-in-lwc/" target="_blank" rel="noopener noreferrer">how to display selected radio button value in lwc</a></li>
                    </ul>
            </div>
 
            <div style="width: 50%; float:left; display:inline-block">
                    <ul style="list-style-type: square; font-size: 16px; margin: 0 0 0 54px; padding: 0;"> 
                        <li><a href="https://www.w3web.net/display-account-related-contacts-lwc/" target="_blank" rel="noopener noreferrer">display account related contacts based on account name in lwc</a></li>
                        <li><a href="https://www.w3web.net/create-lightning-datatable-row-actions-in-lwc/" target="_blank" rel="noopener noreferrer">how to insert a record of account Using apex class in LWC</a></li>
                        <li><a href="https://www.w3web.net/fetch-picklist-values-dynamic-in-lwc/" target="_blank" rel="noopener noreferrer">how to get picklist values dynamically in lwc</a></li>
                        <li><a href="https://www.w3web.net/edit-save-and-remove-rows-dynamically-in-lightning-component/" target="_blank" rel="noopener noreferrer">how to edit/save row dynamically in lightning component</a></li>
                        <li><a href="https://www.w3web.net/update-parent-object-from-child/" target="_blank" rel="noopener noreferrer">update parent field from child using apex trigger</a></li>
                    </ul>
                </div>
               <div style="clear:both;"></div> 
               <br/>
                <div class="youtubeIcon">
                    <a href="https://www.youtube.com/channel/UCW62gTen2zniILj9xE6LmOg" target="_blank" rel="noopener noreferrer"><img src="https://www.w3web.net/wp-content/uploads/2021/11/youtubeIcon.png" width="25" height="25" style="vertical-align:top; margin-right:10px;"/> <strong>TechW3web:-</strong> To know more, Use this <span style="color: #ff8000; font-weight: bold;">Link</span> </a>
                </div>
    </div>
 
</div>
 
  <!--End RelatedTopics Section-->

    </lightning-card>
</template>

<lightning-card>

<lightning-icon icon-name="standard:account" size="small"></lightning-icon> @wire Decorators in Lightning web components with apex method @AuraEnabled (cacheable=true)

</h3>

<lightning-datatable data={accData} columns={columnTable} key-field="Id"></lightning-datatable>

<p data-aura-rendered-by="435:0"><img src="https://www.w3web.net/wp-content/uploads/2021/05/thumbsUpLike.png" width="25" height="25" style="vertical-align:top; margin-right:10px;" data-aura-rendered-by="436:0"><strong data-aura-rendered-by="437:0"><span style="font-size:16px; font-style:italic; display:inline-block; margin-right:5px;">Don't forget to check out:-</span><a href="https://www.w3web.net/" target="_blank" rel="noopener noreferrer" style="text-decoration:none;" data-aura-rendered-by="440:0">An easy way to learn step-by-step online free Salesforce tutorial, To know more Click <span style="color:#ff8000; font-size:18px;" data-aura-rendered-by="442:0">Here..</span></a></strong></p>

<li><a href="https://www.w3web.net/lwc-get-set-lightning-checkbox-value/" target="_blank" rel="noopener noreferrer">How to get selected checkbox value in lwc</a></li>

<li><a href="https://www.w3web.net/display-account-related-contacts-in-lwc/" target="_blank" rel="noopener noreferrer">how to display account related contacts based on AccountId in lwc</a></li>

<li><a href="https://www.w3web.net/create-lightning-datatable-row-actions-in-lwc/" target="_blank" rel="noopener noreferrer">how to create lightning datatable row actions in lwc</a></li>

<li><a href="https://www.w3web.net/if-and-else-condition-in-lwc/" target="_blank" rel="noopener noreferrer">how to use if and else condition in lwc</a></li>

<li><a href="https://www.w3web.net/get-selected-radio-button-value-and-checked-default-in-lwc/" target="_blank" rel="noopener noreferrer">how to display selected radio button value in lwc</a></li>

</ul>

</div>

<li><a href="https://www.w3web.net/display-account-related-contacts-lwc/" target="_blank" rel="noopener noreferrer">display account related contacts based on account name in lwc</a></li>

<li><a href="https://www.w3web.net/create-lightning-datatable-row-actions-in-lwc/" target="_blank" rel="noopener noreferrer">how to insert a record of account Using apex class in LWC</a></li>

<li><a href="https://www.w3web.net/fetch-picklist-values-dynamic-in-lwc/" target="_blank" rel="noopener noreferrer">how to get picklist values dynamically in lwc</a></li>

<li><a href="https://www.w3web.net/edit-save-and-remove-rows-dynamically-in-lightning-component/" target="_blank" rel="noopener noreferrer">how to edit/save row dynamically in lightning component</a></li>

<li><a href="https://www.w3web.net/update-parent-object-from-child/" target="_blank" rel="noopener noreferrer">update parent field from child using apex trigger</a></li>

</ul>

</div>

<br/>

<a href="https://www.youtube.com/channel/UCW62gTen2zniILj9xE6LmOg" target="_blank" rel="noopener noreferrer"><img src="https://www.w3web.net/wp-content/uploads/2021/11/youtubeIcon.png" width="25" height="25" style="vertical-align:top; margin-right:10px;"/> <strong>TechW3web:-</strong> To know more, Use this <span style="color: #ff8000; font-weight: bold;">Link</span> </a>

</div>

</lightning-card>

</template>

Step 2:- Create Lightning Web Component : wireDecoratorsDataTable.js

SFDX:Lightning Web Component >> New >> wireDecoratorsDataTable.js

wireDecoratorsDataTable.js [LWC JavaScript File]

  import { api, LightningElement, track, wire } from 'lwc';
import getAccountList from '@salesforce/apex/lwcAppExampleApex.getAccountList';

import {NavigationMixin} from 'lightning/navigation';

export default class wireDecoratorsDataTable extends NavigationMixin (LightningElement) {
  @api title;
  @api greetings;
  @track greeting;
   
    //Using @wire decorator in lwc for the lightning data table
    @track accData;
    @track errorAccData;     

    @track columnTable =[
        {label:'Name',fieldName:'Name',type:'text'},
        {label:'Phone',fieldName:'Phone',type:'text'},
        {label:'Industry',fieldName:'Industry',type:'text'},
    ];

    @wire(getAccountList)
    
    dataTableAcc({data, error}){
         if(data){
           this.accData = data;
        }
        else if(error){
          this.errorAccData = error;  
        }

    }

}

import { api, LightningElement, track, wire } from 'lwc';

import getAccountList from '@salesforce/apex/lwcAppExampleApex.getAccountList';

import {NavigationMixin} from 'lightning/navigation';

export default class wireDecoratorsDataTable extends NavigationMixin (LightningElement) {

@api title;

@api greetings;

@track greeting;

//Using @wire decorator in lwc for the lightning data table

@track accData;

@track errorAccData;

@track columnTable =[

{label:'Name',fieldName:'Name',type:'text'},

{label:'Phone',fieldName:'Phone',type:'text'},

{label:'Industry',fieldName:'Industry',type:'text'},

];

@wire(getAccountList)

dataTableAcc({data, error}){

if(data){

this.accData = data;

}

else if(error){

this.errorAccData = error;

}

Subscribe My Channel :- Tech W3web - YouTube

Step 3:- Create Lightning Web Component : wireDecoratorsDataTable.js-meta.xml

SFDX:Lightning Web Component >> New >> wireDecoratorsDataTable.js-meta.xml

wireDecoratorsDataTable.js-meta.xml [LWC Meta Data XML]

   <?xml version="1.0" encoding="UTF-8"?>
<LightningComponentBundle xmlns="http://soap.sforce.com/2006/04/metadata">
    <apiVersion>45.0</apiVersion>
    <isExposed>true</isExposed>
    <targets>
        <target>lightning__AppPage</target>
        <target>lightning__RecordPage</target>
        <target>lightning__HomePage</target>
      </targets>
      <targetConfigs>
         <targetConfig targets="lightning__AppPage">
           <property name="title" type="string"/>
           <property name="greetings" type="string"/>
         </targetConfig>
      </targetConfigs>
</LightningComponentBundle>

<?xml version="1.0" encoding="UTF-8"?>

<target>lightning__AppPage</target>

<target>lightning__RecordPage</target>

<target>lightning__HomePage</target>

</targets>

</targetConfig>

</targetConfigs>

</LightningComponentBundle>

Step 5:- Create Lightning Web Component : lwcAppExampleApex.cls

SFDX:Create Apex Class >> New >> lwcAppExampleApex.cls

lwcAppExampleApex.cls [Apex Class]

   public with sharing class lwcAppExampleApex {

    @AuraEnabled (cacheable=true)
    public static List<Account> getAccountList(){
        List<Account> accList = [Select Id, Name, Phone, Industry From Account Where Name !=null limit 5];
        return accList;
    }   

}

public with sharing class lwcAppExampleApex {

@AuraEnabled (cacheable=true)

public static List<Account> getAccountList(){

List<Account> accList = [Select Id, Name, Phone, Industry From Account Where Name !=null limit 5];

return accList;

}

TechW3web:- To know more, Use this Link

Further post that would you like to learn in Salesforce

The Sitemap to Find all Published Post of The Tutorial w3web.net Click Here For More Information

TechW3web:- To know more, Use this Link

FAQ (Frequently Asked Questions)

How do you use a wire decorator in LWC?

When the wire service provisions data, the component rerenders. Components use @wire in their JavaScript class to specify a wire adapter or an Apex method. We need to import the @salesforce/apex scoped module into JavaScript controller class. import apexMethodName from '@salesforce/apex/Namespace.

What is wire adapter in LWC?

Lightning web components(LWC) use a reactive wire service, which is built on Lightning Data Service. Components use @wire in their JavaScript class to read data from one of the wire adapters in the lightning/ui*Api modules and also to call the apex controller server-side methods using wire services.

What is @API @track and @wire?

To track a private property's value and re-render a component when it changes, decorate the property with @track. Tracked properties are also called private reactive properties. @wire. To read Salesforce data, Lightning web components use a reactive wire service.

Author of w3web.net

Hi, This is Vijay Kumar behind the admin and founder of w3web.net. I am a senior software developer and working in MNC company from more than 8 years. I am great fan of technology, configuration, customization & development. Apart of this, I love to write about Blogging in spare time, Working on Mobile & Web application development, Salesforce lightning, Salesforce LWC and Salesforce Integration development in full time. [Read full bio] | | The Sitemap where you can find all published post on w3web.net

6 thoughts on “Retrieving data from Account using @wire Decorators in Lightning web Components with apex method and lightning datatable — LWC | how to fetch account records using @wire decorators in lwc”

EDU CARE JOBS

December 19, 2020 at 8:19 pm

Great work and very useful information.
thanks.
kapil matka

February 20, 2021 at 4:59 am

Best article, very useful and explanation. Your post is extremely incredible. Thank you very much for the new information.
Joganireinforcement

March 8, 2021 at 9:19 am

Great Work and Very Useful Information
5 Internet Approval Site (Do Follow Backlinks)
Carter

April 28, 2021 at 7:24 am

Great Work and Very Useful Information…
Fiona Xu

August 9, 2021 at 6:41 am

this is absolutely helpful blog
satta king

September 12, 2021 at 8:36 am

I things and data online that you might not have heard before on the web.

Hi, I found your site by means of Google

indeed, even as searching for a comparative matter, your site arrived up, it is by all accounts incredible.