How to sort a JSON Object Array

-

 Sorting a JSON Object Array

You might have use sort() method to sort an array, but several time we might have requirement to sort a JSON object array based on a key attribute. In the below example we will learn how to sort a JSON object array.

Code -


function GetSortOrder(prop) {    

    return function(a, b) {    

        if (a[prop] > b[prop]) {    

            return 1;    

        } else if (a[prop] < b[prop]) {    

            return -1;    

        }    

        return 0;    

    }    

}


$.each(data, function(index, value)

                        {                               

                                theArray.push(

                                {

                                        "finalProductsOnSubmit": value.Products,

                                        "finalsubProductsOnSubmit": value.SubProduct,

                                        "finalattributesOnSubmit": value.Attributes,

                                        "finalregionOnSubmit": value.Region,

                                        "finalcountryOnSubmit": value.Country,

                                        "finalvalueOnSubmit": value.Value,

                                        "finalvalueCat": value.Value_x0020_Category

                                });                                 

                        });


theArray.sort(GetSortOrder("finalcountryOnSubmit"));


The above code will sort the JSON Object array based on "finalcountryOnSubmit" value. You may implement same in any of your BAU requirement.


Comments

Post a Comment

Popular posts from this blog

Clear DataTable on button click

-
Image
How to clear DataTable on button click In this post we will learn how we can clear a datatable on a jQuery event. By click on "btnReset" we have to call datatable's destroy method to completely clear a datatable. We may need to clear a datatable on an event. Please follow the below code to achieve the same. HTML - <table id="tblResourcesData" class="display" width="100%" cellspacing="0">           <thead>               <tr>                   <th>Title</th>                   <th>Region</th>                 <th>Country</th>                <th>Email</th>             </tr>           </thead>  </table...
Read more

3D Charts in SharePoint

-
Image
How to create 3D Pie Chart in SharePoint Create a Page and add Script Editor web part to it and paste the below code. Code: <style> #chartdiv {   width: 100%;   height: 500px; } </style> <script type="text/javascript" src="https://canvasjs.com/assets/script/jquery-1.11.1.min.js"></script>  <script src="https://www.amcharts.com/lib/3/amcharts.js"></script> <script src="https://www.amcharts.com/lib/3/pie.js"></script> <script src="https://www.amcharts.com/lib/3/plugins/export/export.min.js"></script> <link rel="stylesheet" href="https://www.amcharts.com/lib/3/plugins/export/export.css" type="text/css" media="all" /> <script src="https://www.amcharts.com/lib/3/themes/light.js"></script> <script type="text/javascript"> $(document).ready(function () { GetListi...
Read more

How to deal with special characters in rest filters

-
Image
Special characters in SharePoint Rest filters You might have noticed while using SharePoint filters with special characters such as '&', '@' or '!' etc. you get error as we need to use encodeURIComponent in the rest api filtering. Below is the working example of filtering data from rest api having special character. Code -  function matchDataFromSPList(val){         $.ajax({                 url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbyTitle('ListName')/items?$filter= ColumnName eq '"+encodeURIComponent(val)+"'",                 type: "GET",                 headers: {                         "Accept": "application/json;odata=verbose"                 },                 async: false,...
Read more