How to sort array using java script or jQuery?

Question

Hi, I have array like below and I wants to sort it based on birthdate of that user. var employees=[]; and after rest api call I have pushed data into employees array and I now I wants to sort it based on bdate {name: "AAA", month: "Mar", bdate: "25"} {name: "BBB", month: "Mar", bdate: "10"} {name: "EEE", month: "Mar", bdate: "28"} {name: "HHH", month: "Mar", bdate: "3"} {name: "QQQ", month: "Mar", bdate: "8"} Please help..

Manav Pandya · Answer

Hello For sorting array there are various ways to do , if you want simple step to sort array Method 1 : Than you can use Array.Sort() inbuilt method using javascript I have given complete snippet that gives you output in sorted order in ascending order Snippet is as follow : function SortArray() { employees.sort(); for ( var i=0;i { $( "#mytable" ).append( " Name :- " + sortedArray[i].name + " Month :- " + sortedArray[i].month + " Birth Date :- " + sortedArray[i].bdate + " " ); } } Just replace above code in my second snippet , you can get desired output Method 2 : You can use Underscore.js for that I have use function : _.sort(Array , 'column_to_be_sorted'); Snippet is as follow : Sorting Array Using Javascript "https://code.jquery.com/jquery-3.3.1.min.js" integrity= "sha256-FgpCb/KJQlLNfOu91ta32o/NMZxltwRo8QtmkMRdAu8=" crossorigin= "anonymous" > "https://cdnjs.cloudflare.com/ajax/libs/underscore.js/1.8.3/underscore-min.js" > Sorting Array Using Javascript "SortArray()" >Sort My Table "mytable" > for getting sorted data --> var employees = []; employees[0] = {name: "AAA" , month: "Mar" , bdate: 25} employees[1] = {name: "BBB" , month: "Mar" , bdate: 10} employees[2] = {name: "EEE" , month: "Mar" , bdate: 28} employees[3] = {name: "HHH" , month: "Mar" , bdate: 3} employees[4] = {name: "QQQ" , month: "Mar" , bdate: 8} function SortArray() { var sortedArray = _.sortBy(employees, 'bdate' ); for ( var i=0;i { $( "#mytable" ).append( " Name :- " + sortedArray[i].name + " Month :- " + sortedArray[i].month + " Birth Date :- " + sortedArray[i].bdate + " " ); } } Output will be : And also there are so many ways like custom logic to sort array and many more you can refer from google Thanks

Manav Pandya · Answer

Hello Code looks good , nothing problem with that I think employees array is seems to be empty , try to debug and check that array contains item or not Bcoz code that i have provided is working fine Make sure to include in head section like : "https://code.jquery.com/jquery-3.3.1.min.js" integrity= "sha256-FgpCb/KJQlLNfOu91ta32o/NMZxltwRo8QtmkMRdAu8=" crossorigin= "anonymous" > Thanks

Manav Pandya · Answer

Hello I told you in Method 1 that if you are using method 1 than you can copy given code in example1 and replace with function in method 2 snippet Let me know if you need help Thanks

Manav Pandya · Answer

Hello Try to remove below code and place functions code inside calling method : remove this -> SortArray(employees); And place the code inside function inside body where you removed above code Thanks

Reshma Bhalekar · Answer

ok. I tried to print in console.log then also it shows all data in employee array but after that its get empty because when i tried to print console.log(employees.length) it is showing 0 I think after sort it gets empty or anything other..

Reshma Bhalekar · Answer

Yes that I understand below is my code // below is required code snippet { for(var i=0 ; i { var accountName = data.d.results[i].LoginName; var user = accountName.replace("#","%23"); $.ajax({ asynch: false, url: "/_api/SP.UserProfiles.PeopleManager/GetPropertiesFor(accountName=@v)?@v='"+user +"'", method: "GET", headers: { "Accept": "application/json; odata=verbose" }, success: function (data1) { if(data1.d.UserProfileProperties != undefined) { var username = data1.d.DisplayName; var birthDate = (data1.d.UserProfileProperties.results[61].Value).split(' ')[0] ; var birthdayMonth = birthDate.split('/')[0]; var birthdayDate = birthDate.split('/')[1]; if( (situation == "Current") || (situation == "prevprev") ||(situation == "nextnext")) { if(birthdayMonth == CurrentMonth) { employees.push({name:username , month:monthname[birthdayMonth-1] , bdate:birthdayDate}); } } } }, error: function (data1) {} }); } SortArray(employees); } function SortArray(employees) { var sortedArray = _.sortBy(employees, 'bdate'); for(var i=0;i { $("#mytable").append("Name :- " + sortedArray[i].name +" Month :- " + sortedArray[i].month +" Birth Date :- " + sortedArray[i].bdate +""); } } it gives me sortedArray.length = 0

Reshma Bhalekar · Answer

Hi Manav, I tried your first method but it is showing "sortedArray" not defined. When I changed it to employees then its showing length as 0 but I use console.log(employees) then it shows all data without sorting.

Sagar Pandurang Kap · Answer

Hi, Refer below links :- https://www.w3schools.com/jsref/jsref_sort.asp https://stackoverflow.com/questions/5503900/how-to-sort-an-array-of-objects-with-jquery-or-javascript Hope it helps....