Sorting an array based on time stamp value from JSON Response

Question

I'm having timestamp value in my json response and is able to parse that value properly. Each image is having its own timestamp value and I need to display it in the increasing timestamp value. That means the last updated image should be loaded first in my application.

The timestamp is in the following format in the JSON Response :

Brand1{
"FileName": "520120427043622011.jpg",
 "UpdateTimeStamp": "Jun 10, 2013 8:31:23 AM"
}

Brand2{
"FileName": "Kung_Fu_Fingers.jpg",
"UpdateTimeStamp": "Jun 5, 2013 6:51:12 AM"
}

Brand3{
"FileName": "google_logo1.jpg",
"UpdateTimeStamp": "Jun 10, 2013 8:31:23 AM"
}

Can any one please guide me to sort the above three brands images item based on the timestamp value using Javascript or jQuery functions. I have used sort function after spliting the date value, but it is sorting the months in alphabetical order only. Please help me out in finding a solution for this.

Thanks in advance.

{ "FileName": "520120427043622011.jpg", "FileUrl": "myserver.com/files/basic/anonymous/api/library/…", "MimeType": "image/jpeg", "TagName": "my_thumb", "FileLength": "243319", "FileDescription": "test", "UpdateTimeStamp": "Jun 10, 2013 7:33:02 AM" }, — Abin Koshy Cheriyan
– Abin Koshy Cheriyan, Commented Jun 10, 2013 at 14:47
I'm able to parse the response. For sorting based on timestamp value I need help.I have stored the timestamp value in an array.Need to sort that array containing timestamp value. — Abin Koshy Cheriyan
– Abin Koshy Cheriyan, Commented Jun 10, 2013 at 14:48

Diode · Accepted Answer · 2013-06-10 17:16:42Z

4

var files = [{
"FileName": "520120427043622011.jpg",
 "UpdateTimeStamp": "Jun 10, 2013 8:31:23 AM"
},{
"FileName": "Kung_Fu_Fingers.jpg",
"UpdateTimeStamp": "Jun 5, 2013 6:51:12 AM"
},{
"FileName": "google_logo1.jpg",
"UpdateTimeStamp": "Jun 10, 2013 8:31:23 AM"
}];

files.sort(function(a, b){
    var d1 = new Date(a.UpdateTimeStamp);
    var d2 = new Date(b.UpdateTimeStamp);
    return d1-d2; // d2-d1 for descending order
});

EDIT:

For array of timestamps

var updateTimeStamps = ["Aug 10, 2013 8:31:23 AM","Jun 5, 2013 6:51:12 AM" ,"May 10, 2013 8:31:23 AM"];

updateTimeStamps.sort(function(a, b){
    var d1 = new Date(a);
    var d2 = new Date(b);
    return d1-d2; // d2-d1 for descending order
});

console.log(updateTimeStamps);

EDIT 2: For keeping two arrays and sorting

var imgs = ["img1", "img2", "img3"];
var times = ["Jul 10, 2013 8:31:23 AM","Jan 5, 2013 6:51:12 AM" ,"Feb 10, 2013 8:31:23 AM"];

var sorting = [];
times.sort(function(a, b){
    var d1 = new Date(a);
    var d2 = new Date(b);
    var d =  d1-d2; // d2-d1 for descending order
    sorting.push(d);
    return d;
});

imgs.sort(function(a, b){
    return sorting.shift();
});

console.log(times);
console.log(imgs);

edited Jun 10, 2013 at 17:16

answered Jun 10, 2013 at 14:50

Diode

25.2k8 gold badges43 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

16 Comments

Abin Koshy Cheriyan Over a year ago

callback({ "Brands": [ [{ "FileName": "520120427043622011.jpg", "UpdateTimeStamp": "Jun 10, 2013 8:31:23 AM" },{ "FileName": "Kung_Fu_Fingers.jpg", "UpdateTimeStamp": "Jun 5, 2013 6:51:12 AM" },{ "FileName": "google_logo1.jpg", "UpdateTimeStamp": "Jun 10, 2013 8:31:23 AM" }]; })

Abin Koshy Cheriyan Over a year ago

I have tried the above code previously and it will return in alphabetical order only.Eg: Aug,June,May like wise and not based on the above response.

Abin Koshy Cheriyan Over a year ago

Can you please explain the tokens you are using.What all are the values I need to use in my code.I have stored the timestamp data in updatetimestamp array. In the above code what are the value for files,a,b?

Abin Koshy Cheriyan Over a year ago

I need to sort the array - updatetimestamp which contains the fetched timestamp value.

Diode Over a year ago

please share a sample array

|

Blauharley · Accepted Answer · 2013-06-10 15:36:38Z

3

you can define insertion-sort, that executes in O(n)-time (best-case, array is sorted), and O(n^2) array is not sorted (worst case):

function insertionSort(files,attrToSortBy){
  for(var k=1; k < files.length; k++){
     for(var i=k; i > 0 && new Date(files[i][attrToSortBy]) < 
       new Date(files[i-1][attrToSortBy]); i--){

        var tmpFile = files[i];
        files[i] = files[i-1];
        files[i-1] = tmpFile;

     }
  }

}

var files = [{
     "FileName": "520120427043622011.jpg",
     "UpdateTimeStamp": "Jun 10, 2013 8:31:23 AM"
   },{
     "FileName": "Kung_Fu_Fingers.jpg",
     "UpdateTimeStamp": "Jun 5, 2013 6:51:12 AM"
   },{
     "FileName": "google_logo1.jpg",
     "UpdateTimeStamp": "Jun 12, 2013 8:31:23 AM"
}];

insertionSort(files,"UpdateTimeStamp");

console.log('files: ',files);

answered Jun 10, 2013 at 15:36

Blauharley

4,2546 gold badges31 silver badges49 bronze badges

3 Comments

Abin Koshy Cheriyan Over a year ago

This will also return files as [object Object] value when I put alert(files); How will you get the values inside files.

Abin Koshy Cheriyan Over a year ago

Can I sort two more arrays using the same time stamp value order?

Blauharley Over a year ago

This sort-algo can be used with arrays, objects and all other data-structures.

Collectives™ on Stack Overflow

Sorting an array based on time stamp value from JSON Response

2 Answers 2

16 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

16 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related