How can I retrieve the most recent date from a collection of hashes and then extract the corresponding name key/value pair?

Question

How can I retrieve the most recent date from a collection of hashes and then extract the corresponding name key/value pair?

I am dealing with an array of hashes structured like this:

[
 {
  "Address": 25,
  "AlertType": 1,
  "Area": "North",
  "MeasureDate": "2019-02-01T00:01:01.001Z",
  "MeasureValue": -1
 },
{
  "Address": 26,
  "AlertType": 1,
  "Area": "West",
  "MeasureDate": "2016-04-12T15:13:11.733Z",
  "MeasureValue": -1
},
{
  "Address": 25,
  "AlertType": 1,
  "Area": "North",
  "MeasureDate": "2017-02-01T00:01:01.001Z",
  "MeasureValue": -1
}
      .
      .
      .
]

My task is to identify the most recent date in the array and return the corresponding Address value. I have successfully found the newest date using the following code:

let newest = new Date(Math.min.apply(null, data.map(function(e) {
  return new Date(e.created_at);
})));
most_recent = newest;

However, I am struggling to retrieve the Address value. The code I've written only returns the date or address from the

let findEarliest = (name) => {
  let nameIndex = 0;
  data.forEach((date) => {
    if(date.created_at.includes(most_recent));
      nameIndex = data.indexOf(date);
  });
  return data[nameIndex].name;
};

Any assistance on this issue would be greatly appreciated.

javascript arrays date hash max

Answer 1

Answer №1

Give this a try. It organizes the ~~hash~~ array based on MeasureDate and then retrieves the address of the first element.

const hash = [
   {
  "Address": 1,
  "AlertType": 1,
  "Area": "North",
  "MeasureDate": "2010-02-01T00:01:01.001Z",
  "MeasureValue": -1
 },
 {
  "Address": 25,
  "AlertType": 1,
  "Area": "North",
  "MeasureDate": "2019-02-01T00:01:01.001Z",
  "MeasureValue": -1
 },
{
  "Address": 26,
  "AlertType": 1,
  "Area": "West",
  "MeasureDate": "2016-04-12T15:13:11.733Z",
  "MeasureValue": -1
},
{
  "Address": 20,
  "AlertType": 1,
  "Area": "North",
  "MeasureDate": "2017-02-01T00:01:01.001Z",
  "MeasureValue": -1
}
]

const latestAddress = hash.sort((a, b) => b.MeasureDate > a.MeasureDate)[0].Address

console.log(latestAddress)

Answer 2

Give this a try. It organizes the ~~hash~~ array based on MeasureDate and then retrieves the address of the first element.

const hash = [
   {
  "Address": 1,
  "AlertType": 1,
  "Area": "North",
  "MeasureDate": "2010-02-01T00:01:01.001Z",
  "MeasureValue": -1
 },
 {
  "Address": 25,
  "AlertType": 1,
  "Area": "North",
  "MeasureDate": "2019-02-01T00:01:01.001Z",
  "MeasureValue": -1
 },
{
  "Address": 26,
  "AlertType": 1,
  "Area": "West",
  "MeasureDate": "2016-04-12T15:13:11.733Z",
  "MeasureValue": -1
},
{
  "Address": 20,
  "AlertType": 1,
  "Area": "North",
  "MeasureDate": "2017-02-01T00:01:01.001Z",
  "MeasureValue": -1
}
]

const latestAddress = hash.sort((a, b) => b.MeasureDate > a.MeasureDate)[0].Address

console.log(latestAddress)

Answer 3

Answer №2

Here is a code snippet that may be useful:

Updated on 08/17/2017:

RobG recommended this code as the most optimal solution.

Optimal solution:

const lastAddresDetails = addressList.sort((a, b) => b.MeasureDate.localeCompare(a.MeasureDate))[0];

console.log(lastAddresDetails.Address)

Alternative approaches:

const lastAddresDetails = addressList.sort((a, b) => b.MeasureDate > a.MeasureDate)[0];

console.log(lastAddresDetails.Address)

or

var lastAdressDetails = addressList.sort(function (a, b) {
            return b.MeasureDate > a.MeasureDate;
        })[0];

console.log(lastAdressDetails.Address);

Answer 4

Here is a code snippet that may be useful:

Updated on 08/17/2017:

RobG recommended this code as the most optimal solution.

Optimal solution:

const lastAddresDetails = addressList.sort((a, b) => b.MeasureDate.localeCompare(a.MeasureDate))[0];

console.log(lastAddresDetails.Address)

Alternative approaches:

const lastAddresDetails = addressList.sort((a, b) => b.MeasureDate > a.MeasureDate)[0];

console.log(lastAddresDetails.Address)

or

var lastAdressDetails = addressList.sort(function (a, b) {
            return b.MeasureDate > a.MeasureDate;
        })[0];

console.log(lastAdressDetails.Address);

How can I retrieve the most recent date from a collection of hashes and then extract the corresponding name key/value pair?

Answer №1

Answer №2

Similar questions

What is the best way to clear an array?

Loading Embedded Content with ReactJS

Capture microphone and audio in a SIP call with sip.js

Is there a constraint on JSON data?

Refresh in AJAX, automated loading for seamless transition to a different page

Java: Functions Not Running As Expected

Can you please provide the Jquery alternative to this?

Modify Chartjs label color onClick while retaining hover functionality

A comprehensive guide on utilizing the loading.tsx file in Next JS

AngularJS controller containing a nested app

Tips for updating mongoose user data with associated posts that share the same user id

Having trouble getting OrbitControls to function properly in Object-Oriented Programming (OOP)

Issue: React child must be a valid object - Runtime Error Detected

Tips for splitting a container of specific height into sections measuring 80% and 20%

Struggling to remove the image tag from the jQuery ajax response

Tips for seamlessly playing flowplayer while an mp4 file is loading?

Is there a better approach to verifying an error code in a `Response` body without relying on `clone()` in a Cloudflare proxy worker?

Issue: why is EPIPE being written on sendFile()?

Angular encountered an issue with an HTTP POST request, as the 'Access-Control-Allow-Origin' header was not found on the requested resource

Effective ways to retrieve API response data in React JS