How to return data from multiple objects using wrapper class in lightning component | wrapper class instances in lightning component to return data from multiple objects and delete selected row on click delete button in Salesforce

Post Views: 5,249

Hey guys, In this post we are going to learn about how to write inner query in Salesforce. And how to fetch data from multiple custom sObject using wrapper apex class in lightning component.

Also in this example we will achieving that how to delete child record if child record has a lookup relationship to the parent sObject.

Don’t forget to check out:- Editing row, Saving row and Removing rows Dynamically in Lightning component Salesforce Click Here For More Information

Files we used in this post example →

wrapperCustomObjCmp.cmp	Lightning Component	It is used for display the Input filed of name, address, email, and button Icon of delete on the table.
wrapperCustomObjCmpConroller.js	JavaScript Controller File	It is used for communicate to server side apex method and fetch the record using init fuction.
wrapperCustomObjCmpHelper.js	JavaScript Helper File	It is used for refresh the page after delete the record.
wrapperCustomObjCmp.CSS	Component Style CSS	It is used for creat a custom delete icon from resource.
wrapperCustomObjCtrCmp.apxc	Apex Class Controller	It is used for delete and fetching the records from multiple sObject from database server
Custom Parent Object:- NewStudent__c Custom Parent Object Fields:- Name, Email__c Address__c Custom Child Lookup Object:- Registration__c Custom Child Object Fields:- Name, RegNewStudent__r.Name RegCourse__r.Name DateOfRegistration__c	Custom Object and their fields	In this post we used two type of custom sObject. first is Parent object (NewStudent__c) and another is child sObject (Registration__c). We are achieving that how to fetch records from two custom objects and how to delete child record in Lookup relationship..

Final Output →

Other related post that would you like to learn in lightning component.

Create Lightning Component →

Step 1:- Create Lightning Component : wrapperCustomObjCmp.cmp

From Developer Console >> File >> New >> Lightning Component >> wrapperCustomObjCmp.cmp

wrapperCustomObjCmp.cmp [Lightning Component File]

   <aura:component controller="wrapperCustomObjCtrCmp" implements="force:appHostable,flexipage:availableForAllPageTypes,flexipage:availableForRecordHome,force:hasRecordId,forceCommunity:availableForAllPageTypes,force:lightningQuickAction,lightning:isUrlAddressable" access="global" >
    
    <aura:attribute name="wrapListItems" type="NewStudent__c[]"/>
    <aura:handler name="init" value="{!this}" action="{!c.doInit}"/>
    <aura:attribute name="recSelectId" type="String" default=""/>
    
    <div class="slds slds-p-horizontal--medium">
        <table class="slds-table slds-table--bordered slds-table--col-bordered" style="border-collapse:collapse;">
            <thead> 
                <tr>
                    <th>Student Name</th>
                    <th>Address</th>
                    <th>Email</th>
                    <th>Registration No.</th>
                    <th>Registered Student Name</th>
                    <th>Registered Course Name</th>
                    <th>Registration Date</th>
                    <th></th>                    
                </tr>
            </thead>
            <tbody>
                <aura:iteration items="{!v.wrapListItems}" var="wrapVar" indexVar="index">
                    <tr id="{!wrapVar.recStudentId}">
                        <td>{!wrapVar.studentName}</td>                        
                        <td>{!wrapVar.studentAddress}</td>
                        <td>{!wrapVar.studentEmail}</td>
                        <td>{!wrapVar.regNum}</td>
                        <td>{!wrapVar.regStudentName}</td>
                        <td>{!wrapVar.regCourseName}</td>
                        <td>{!wrapVar.regDateOfReg}</td>                        
                        <td>        
                             <a href="javascript:void(0);"><span class="delSpan slds-m-left--small" title="Delete" onclick="{!c.deleteRowId}" 
                                                                        data-sfid="{!wrapVar.recStudentId}"
                                                                        data-index="{!index}"></span></a>
                       </td>                        
                    </tr>
                </aura:iteration>
            </tbody>
        </table>

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


    </div>    
</aura:component>

<aura:component controller="wrapperCustomObjCtrCmp" implements="force:appHostable,flexipage:availableForAllPageTypes,flexipage:availableForRecordHome,force:hasRecordId,forceCommunity:availableForAllPageTypes,force:lightningQuickAction,lightning:isUrlAddressable" access="global" >

<aura:attribute name="wrapListItems" type="NewStudent__c[]"/>

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

<aura:attribute name="recSelectId" type="String" default=""/>

<thead>

<tr>

<th>Student Name</th>

<th>Address</th>

<th>Email</th>

<th>Registration No.</th>

<th>Registered Student Name</th>

<th>Registered Course Name</th>

<th>Registration Date</th>

</tr>

</thead>

<tbody>

<aura:iteration items="{!v.wrapListItems}" var="wrapVar" indexVar="index">

<td>{!wrapVar.studentName}</td>

<td>{!wrapVar.studentAddress}</td>

<td>{!wrapVar.studentEmail}</td>

<td>{!wrapVar.regNum}</td>

<td>{!wrapVar.regStudentName}</td>

<td>{!wrapVar.regCourseName}</td>

<td>{!wrapVar.regDateOfReg}</td>

<td>

<a href="javascript:void(0);"><span class="delSpan slds-m-left--small" title="Delete" onclick="{!c.deleteRowId}"

data-sfid="{!wrapVar.recStudentId}"

data-index="{!index}"></span></a>

</td>

</tr>

</aura:iteration>

</tbody>

</table>

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

</div>

</aura:component>

Create JavaScript Controller →

Step 2:- Create Lightning Component : wrapperCustomObjCmpConroller.js

From Developer Console >> File >> New >> Lightning Component >> JavaScript Controller

wrapperCustomObjCmpConroller.js [JavaScript Controller]

  ({
	doInit : function(component, event, helper) {
	  var action = component.get("c.appCustomWrapListMthd");         
        action.setCallback(this, function(response){
            var state = response.getState();
            
            if(state=='SUCCESS'){
                var result = response.getReturnValue();              
                component.set('v.wrapListItems',result);
            }
        });
        $A.enqueueAction(action);
	},
    
    deleteRowId:function(component,event,helper){
        var sfid = event.target.dataset.sfid;        
        var action =component.get('c.delectRecId');       
        action.setParams({'delRecId':sfid});
        action.setCallback(this, function(response){
            var state = response.getState();
            if(state == 'SUCCESS'){
                var result = response.getReturnValue();                
                var wrapListItems = component.get( "v.wrapListItems" );
                component.set( "v.wrapListItems", wrapListItems );
                helper.refreshView(component);
                //alert('record deleted successfully');
                
                var eventToast = $A.get("e.force:showToast");
                eventToast.setParams({
                    "title":'Success',
                    "type":'success',
                    "message":'Record deleted successfully.'
                   });
                 eventToast.fire();
                
            }
        });
        $A.enqueueAction(action);
    },
    
})

({

doInit : function(component, event, helper) {

var action = component.get("c.appCustomWrapListMthd");

action.setCallback(this, function(response){

var state = response.getState();

if(state=='SUCCESS'){

var result = response.getReturnValue();

component.set('v.wrapListItems',result);

}

});

$A.enqueueAction(action);

deleteRowId:function(component,event,helper){

var sfid = event.target.dataset.sfid;

var action =component.get('c.delectRecId');

action.setParams({'delRecId':sfid});

action.setCallback(this, function(response){

var state = response.getState();

if(state == 'SUCCESS'){

var result = response.getReturnValue();

var wrapListItems = component.get( "v.wrapListItems" );

component.set( "v.wrapListItems", wrapListItems );

helper.refreshView(component);

//alert('record deleted successfully');

var eventToast = $A.get("e.force:showToast");

eventToast.setParams({

"title":'Success',

"type":'success',

"message":'Record deleted successfully.'

});

eventToast.fire();

}

});

$A.enqueueAction(action);

})

Create JavaScript Helper →

Step 3:- Create Lightning Component : wrapperCustomObjCmpHelper.js

From Developer Console >> File >> New >> Lightning Component >> JavaScript Helper

wrapperCustomObjCmpHelper.js [JavaScript Helper File]

   ({
	refreshView : function(component, event, helper) {
		var action = component.get("c.appCustomWrapListMthd"); 
        
        action.setCallback(this, function(response){
            var state = response.getState();
            //alert(state);
            if(state=='SUCCESS'){
                var result = response.getReturnValue();
               // alert('result ' + JSON.stringify(result));
                component.set('v.wrapListItems',result);
            }
        });
        $A.enqueueAction(action);
	}
})

({

refreshView : function(component, event, helper) {

var action = component.get("c.appCustomWrapListMthd");

action.setCallback(this, function(response){

var state = response.getState();

//alert(state);

if(state=='SUCCESS'){

var result = response.getReturnValue();

// alert('result ' + JSON.stringify(result));

component.set('v.wrapListItems',result);

}

});

$A.enqueueAction(action);

}

})

Create Component Style CSS →

Step 4:- Create Lightning Component Style CSS: wrapperCustomObjCmp.CSS

From Developer Console >> File >> New >> Lightning Component >> Style CSS

wrapperCustomObjCmp.CSS [JavaScript Helper File]

Note:-Static resource custom delete icon

You need to upload a custom delete icon on resource file.

   .THIS {
}
.THIS .slds-table thead tr th{background-color:#eee;}
.THIS .slds-table thead tr th, .THIS .slds-table tbody tr td {border:1px #dddbda solid; border-collapse: collapse; white-space: normal;}

.THIS .delSpan:before{content:''; width:17px; height:17px; display:inline-block; background:url(/resource/delete) no-repeat left top; background-size:cover; cursor: pointer;}

.THIS {

}

.THIS .slds-table thead tr th{background-color:#eee;}

.THIS .slds-table thead tr th, .THIS .slds-table tbody tr td {border:1px #dddbda solid; border-collapse: collapse; white-space: normal;}

.THIS .delSpan:before{content:''; width:17px; height:17px; display:inline-block; background:url(/resource/delete) no-repeat left top; background-size:cover; cursor: pointer;}

Create Apex Class Controller →

Step 5:- Create Apex Class : wrapperCustomObjCtrCmp.apxc

From Developer Console >> File >> New >> Apex Class

wrapperCustomObjCtrCmp.apxc [Apex Class Controller]

   public class wrapperCustomObjCtrCmp {    
   
    public class wrapperCustomClass{
        @AuraEnabled
        public string studentName;
        @AuraEnabled
        public string studentEmail;
        @AuraEnabled
        public string studentAddress;
        @AuraEnabled
        public Id recStudentId;       
       
        @AuraEnabled
        public string regNum;
        @AuraEnabled
        public string regStudentName;
        @AuraEnabled
        public string regCourseName;
        @AuraEnabled
        public date regDateOfReg;      
        
        public wrapperCustomClass(string studentName, string studentEmail, string studentAddress, Id recStudentId,
                                                       string regNum,string regStudentName,string regCourseName,date regDateOfReg){
         this.studentName = studentName;
         this.studentEmail = studentEmail;
         this.studentAddress = studentAddress;  
         this.recStudentId = recStudentId;           
                                     
         this.regNum = regNum;
         this.regStudentName = regStudentName;
         this.regCourseName = regCourseName; 
         this.regDateOfReg = regDateOfReg;         
        
        }
        
    }
    
    
    @AuraEnabled
    public static List<wrapperCustomClass> appCustomWrapListMthd(){
       List<NewStudent__c> newStudent = new List<NewStudent__c>();
       List<Registration__c> newRegistration = new  List<Registration__c>();
       List<wrapperCustomClass> custWrapObj = new  List<wrapperCustomClass>();    
        
       List<NewStudent__c> newStudentView =[Select Id, Name, Email__c, Address__c,(Select Id, Name, RegNewStudent__r.Name, RegCourse__r.Name, DateOfRegistration__c From Registrations__r) From NewStudent__c];
        
        newRegistration = [Select Id, Name, RegNewStudent__r.Name, RegCourse__r.Name, DateOfRegistration__c From Registration__c ];
            
        for(NewStudent__c studentObj:newStudentView){
            
            for(Registration__c regObj:studentObj.Registrations__r){
                 custWrapObj.add(new wrapperCustomClass(studentObj.Name,studentObj.Email__c, studentObj.Address__c,
                                                  studentObj.Id,regObj.Name,regObj.RegNewStudent__r.Name,regObj.RegCourse__r.Name,regObj.DateOfRegistration__c));
            }
           
        }
        return custWrapObj;
    }
    
   
    @AuraEnabled
    public static List<NewStudent__c> delectRecId(Id delRecId){
        delete [Select Id, (Select Id From Registrations__r Where RegNewStudent__c=:delRecId) From NewStudent__c Where Id=:delRecId];
        List<NewStudent__c> listStudent = [Select Id, Name, Email__c, Address__c,(Select Id, Name, RegNewStudent__r.Name, RegCourse__r.Name, DateOfRegistration__c From Registrations__r) From NewStudent__c];
        return listStudent;
    }
     
}

public class wrapperCustomObjCtrCmp {

public class wrapperCustomClass{

@AuraEnabled

public string studentName;

@AuraEnabled

public string studentEmail;

@AuraEnabled

public string studentAddress;

@AuraEnabled

public Id recStudentId;

@AuraEnabled

public string regNum;

@AuraEnabled

public string regStudentName;

@AuraEnabled

public string regCourseName;

@AuraEnabled

public date regDateOfReg;

public wrapperCustomClass(string studentName, string studentEmail, string studentAddress, Id recStudentId,

string regNum,string regStudentName,string regCourseName,date regDateOfReg){

this.studentName = studentName;

this.studentEmail = studentEmail;

this.studentAddress = studentAddress;

this.recStudentId = recStudentId;

this.regNum = regNum;

this.regStudentName = regStudentName;

this.regCourseName = regCourseName;

this.regDateOfReg = regDateOfReg;

}

@AuraEnabled

public static List<wrapperCustomClass> appCustomWrapListMthd(){

List<NewStudent__c> newStudent = new List<NewStudent__c>();

List<Registration__c> newRegistration = new List<Registration__c>();

List<wrapperCustomClass> custWrapObj = new List<wrapperCustomClass>();

List<NewStudent__c> newStudentView =[Select Id, Name, Email__c, Address__c,(Select Id, Name, RegNewStudent__r.Name, RegCourse__r.Name, DateOfRegistration__c From Registrations__r) From NewStudent__c];

newRegistration = [Select Id, Name, RegNewStudent__r.Name, RegCourse__r.Name, DateOfRegistration__c From Registration__c ];

for(NewStudent__c studentObj:newStudentView){

for(Registration__c regObj:studentObj.Registrations__r){

custWrapObj.add(new wrapperCustomClass(studentObj.Name,studentObj.Email__c, studentObj.Address__c,

studentObj.Id,regObj.Name,regObj.RegNewStudent__r.Name,regObj.RegCourse__r.Name,regObj.DateOfRegistration__c));

}

return custWrapObj;

}

@AuraEnabled

public static List<NewStudent__c> delectRecId(Id delRecId){

delete [Select Id, (Select Id From Registrations__r Where RegNewStudent__c=:delRecId) From NewStudent__c Where Id=:delRecId];

List<NewStudent__c> listStudent = [Select Id, Name, Email__c, Address__c,(Select Id, Name, RegNewStudent__r.Name, RegCourse__r.Name, DateOfRegistration__c From Registrations__r) From NewStudent__c];

return listStudent;

}

TechW3web:- To know more, Use this Link

Further post that would you like to learn in lightning component.

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

To Find Some Important Additional Information

If you think you and your family members also like to earn money in additional time, then go this link. In this site, you can earn money for the lifetime at low effort. To Earn Unlimited Everyday With This Trick, Sign Up Free and Get Magic.. Get Started for Free

Author of w3web.net

Hi, This is Vijay 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

8 thoughts on “How to return data from multiple objects using wrapper class in lightning component | wrapper class instances in lightning component to return data from multiple objects and delete selected row on click delete button in Salesforce”

M Tariq

September 5, 2020 at 10:48 am

Nice post very informative……..
Stock Homes

September 9, 2020 at 7:14 am

You Can Join Stock Market Classes In IndoreBest NISM & Trading Share Market Technical Analysis
sharegiants

October 21, 2020 at 7:03 am

Nice post very informative
Ahsan khan

November 18, 2020 at 2:00 pm

Good Ainformative articel
Shahriar

December 8, 2020 at 4:04 pm

Ow great i am looking for this article. Thank you so much.
Joganiwellness

February 4, 2021 at 9:25 am

Wooww !!! Great Post
5 Internet Approval Site (Do Follow Backlinks)
Carter

April 28, 2021 at 10:17 am

Wooww !!! Great Post…
Fiona Xu

August 9, 2021 at 7:02 am

Amazing article, and I have learned a lot

How to return data from multiple objects using wrapper class in lightning component | wrapper class instances in lightning component to return data from multiple objects and delete selected row on click delete button in Salesforce

Files we used in this post example →

Create Lightning Component →

wrapperCustomObjCmp.cmp [Lightning Component File]

Create JavaScript Controller →

wrapperCustomObjCmpConroller.js [JavaScript Controller]

Create JavaScript Helper →

wrapperCustomObjCmpHelper.js [JavaScript Helper File]

Create Component Style CSS →

wrapperCustomObjCmp.CSS [JavaScript Helper File]

Note:-Static resource custom delete icon

Create Apex Class Controller →

wrapperCustomObjCtrCmp.apxc [Apex Class Controller]

Related Topics | You May Also Like

Author of w3web.net

8 thoughts on “How to return data from multiple objects using wrapper class in lightning component | wrapper class instances in lightning component to return data from multiple objects and delete selected row on click delete button in Salesforce”

Leave a Comment Cancel reply