lwc datatable with sorting of columns ascending and descending order of account object's fields Uses of 'lightning-datatable' elements in Salesforce -- LWC | How to sorting of columns ascending and descending order in lwc

Hey guys, today in this post we are going to learn about How to sorting of columns ascending and descending order of account object’s fields Uses of ‘lightning-datatable’ elements in Salesforce Lightning Web Component — LWC.

Here I am creating lwc datatable with sorting the columns of Account Object by ascending and descending order in lightning web component (LWC).

Don’t forget to check out:- Create custom lwc datatable with sorting of columns by ascending and descending order Click Here For More Information

Files we used in this post example

lwcSortingDataTable.html	LWc HTML File	Template HTML file to create datatable with sorting of columns by Ascending & Descending Order in lwc
lwcSortingDataTable.js	LWC JavaScript File	It’s hold a javascript on click function to sorting the column of Account Object by Ascending & Descending Order.
lwcSortingDataTable.js-meta.xml	XML Meta File	It is used to where this lightning web component file you want to display as like lightning__AppPage, lightning__RecordPage, lightning__HomePage.
lwcSortingDataTableCtrl.cls	Apex Class Controller	It is used for fetching the data of Account from server.

Final Output

👉 Download Free Ebook →

👉 Get Free Course →

Note:: – You will get an email, so put correct email and mobile number and BEGIN YOUR JOURNEY from Today!

sort columns in ascending and descending order in lwc -- w3web.net

You can download file directly from github by Click Here.

Other related post that would you like to learn in Salesforce

Find the below steps

Create Lightning Web Component HTML

Step 1:- Create Lightning Web Component HTML ➡ lwcSortingDataTable.html

SFDX:Lightning Web Component ➡ New ➡ lwcSortingDataTable.html

lwcSortingDataTable.html [Lightning Web Component HTML]

Note:: – You will get an email, so put correct email and mobile number and BEGIN YOUR JOURNEY from Today!

```
   <template>
```

    <lightning-card title="Data-Table with sorting of columns by ascending and descending order in LWC" icon-name="standard:account" > <br/>

```
        <div style="width: auto;">
```
```
            <template if:true={data}>
```

                <lightning-datatable data={data}

                                     columns={columns}

                                     key-field="id"

                                     sorted-by={sortBy}

                                     sorted-direction={sortDirection}

                                     onsort={handleSortAccountData}

                                     hide-checkbox-column="true"></lightning-datatable>

```
            </template>
```
```
 
```
```
        </div>
```
```
<br/><br/>
```
```
   
```

<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>
```
```
 
```
```
  
```
```
 
```
```
   </lightning-card> 
```
```
</template>
```
```
 
```
```
    </lightning-card>
```
```
</template>
```

Create Lightning Web Component Javascript

Step 2:- Create Lightning Web Component Javascript ➡ lwcSortingDataTable.js

SFDX:Lightning Web Component ➡ New ➡ lwcSortingDataTable.js

lwcSortingDataTable.js [LWC JavaScript File]

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

import sortAccountItem from '@salesforce/apex/lwcSortingDataTableCtrl.sortAccountList';

```
const columns = [
```
```
    {
```
```
        label: 'Name',
```
```
        fieldName: 'Name',
```
```
        sortable: "true"
```
```
    }, {
```
```
        label: 'Phone',
```
```
        fieldName: 'Phone',
```
```
        sortable: "true"
```
```
    }, {
```
```
        label: 'Industry',
```
```
        fieldName: 'Industry',
```
```
        type: 'Picklist',
```
```
        sortable: "true"
```
```
    }, {
```
```
        label: 'Type',
```
```
        fieldName: 'Type',
```
```
        type: 'Picklist',
```
```
        sortable: "true"
```
```
    }, {
```
```
        label: 'Website',
```
```
        fieldName: 'Website',
```
```
        type: 'URL',
```
```
        sortable: "true"
```
```
    },
```
```
];
```

export default class LwcSortingDataTable extends LightningElement {

```
    @track data;
```
```
    @track columns = columns;
```
```
    @track sortBy;
```
```
    @track sortDirection;
```
```
    @wire(sortAccountItem)
```
```
    accounts(result) {
```
```
        if (result.data) {
```
```
            this.data = result.data;
```
```
            this.error = undefined;
```
```
 
```
```
        } else if (result.error) {
```
```
            this.error = result.error;
```
```
            this.data = undefined;
```
```
        }
```
```
    }
```
```
 
```
```
 
```

    handleSortAccountData(event) {

        this.sortBy = event.detail.fieldName;

        this.sortDirection = event.detail.sortDirection;

        this.sortAccountData(event.detail.fieldName, event.detail.sortDirection);

```
    }
```
```
 
```

    sortAccountData(fieldname, direction) {

```
 
```

        let parseData = JSON.parse(JSON.stringify(this.data));

```
 
```
```
        let keyValue = (a) => {
```
```
            return a[fieldname];
```
```
        };
```
```
 
```

       let isReverse = direction === 'asc' ? 1: -1;

```
 
```
```
           parseData.sort((x, y) => {
```

            x = keyValue(x) ? keyValue(x) : '';

            y = keyValue(y) ? keyValue(y) : '';

```
 
```

            return isReverse * ((x > y) - (y > x));

```
        });
```
```
 
```
```
        this.data = parseData;
```
```
 
```
```
    }
```
```
 
```
```
}
```

Create Lightning Web Component Meta XML

Step 3:- Create Lightning Web Component Meta XML ➡ lwcSortingDataTable.js-meta.xml

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

lwcSortingDataTable.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>
```
```
</LightningComponentBundle>
```

Create Apex Class Controller

Step 4:- Create Apex Controller ➡ lwcSortingDataTableCtrl.cls

SFDX:Create Apex Class ➡ New ➡ lwcSortingDataTableCtrl.cls

lwcSortingDataTableCtrl.cls [Apex Class]

   public WITH sharing class lwcSortingDataTableCtrl {

```
 
```
```
    @AuraEnabled(Cacheable = TRUE)
```

    public static List<Account> sortAccountList(){

        List<Account> accListObj= [SELECT Id, Name, Phone, Industry, Description, TYPE, Website FROM Account WHERE Phone != NULL LIMIT 20 ];

```
        RETURN accListObj;
```
```
    }
```
```
 
```
```
}
```

sort columns in ascending and descending order in lwc -- w3web.net

Salesforce LWC, Aura Lightning Tutorial:- To learn step-by-step, 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 I sort multiple columns in DataTable?

DataTables allows ordering by multiple columns at the same time, which can be activated in a number of different ways:User shift click on a column.

How do I sort a column in DataTable?

Using the order initialisation parameter, you can set the table to display the data in exactly the order that you want.

What is default view in DataTable?

The DefaultView property returns a DataView you can use to sort, filter, and search a DataTable.

Vijay Kumar

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

lwc datatable with sorting of columns ascending and descending order of account object’s fields Uses of ‘lightning-datatable’ elements in Salesforce — LWC | How to sorting of columns ascending and descending order in lwc

Files we used in this post example

Note:: – You will get an email, so put correct email and mobile number and BEGIN YOUR JOURNEY from Today!

Create Lightning Web Component HTML

lwcSortingDataTable.html [Lightning Web Component HTML]

Note:: – You will get an email, so put correct email and mobile number and BEGIN YOUR JOURNEY from Today!

Create Lightning Web Component Javascript

lwcSortingDataTable.js [LWC JavaScript File]

Create Lightning Web Component Meta XML

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

Create Apex Class Controller

lwcSortingDataTableCtrl.cls [Apex Class]

How do I sort multiple columns in DataTable?

How do I sort a column in DataTable?

What is default view in DataTable?

Related Topics | You May Also Like

Note:: – You will get an email, so put correct email and mobile number and BEGIN YOUR JOURNEY from Today!

Vijay Kumar

Leave a Comment Cancel reply