Retrieve a collection of duplicate objects and choose the one with the most recent date

Question

Retrieve a collection of duplicate objects and choose the one with the most recent date

Having trouble figuring out how to solve a problem with manipulating an Object Array called items. The array contains four items in total.

  const items: any[] = await sp.web.lists.getByTitle("List")
          .items.select("ID, Part, Level, MyDate")
          .filter("Part eq 1")
          .getAll();

The issue I'm facing is how to manipulate the Array to achieve the following:

Identify and remove duplicates for Level, leaving only one of each value;
From the remaining unique values, eliminate the item with the oldest Date.

Unfortunately, I haven't been able to find a solution through my own research yet. Any help from the community would be greatly appreciated!

arrays typescript object

Answer 1

Answer №1

In searching for a resolution to my issue, I often find that a heavy workload can hinder progress.

//Identify and eliminate duplicates based on specific criteria
workItems = items

const lookup: any[] = workItems.reduce((a, e) => {
  a[e.Level] = ++a[e.Level] || 0;
  return a;
}, {});


const levels = workItems.filter(e => lookup[e.Level]);

//Determine the most recent date among duplicates and remove older instances
let isLast = levels[0];
for (let date of levels) {
  if (moment(date.YourDateField) > moment(isLast.YourDateField)) {
    isLast = date;
  }
}

Answer 2

In searching for a resolution to my issue, I often find that a heavy workload can hinder progress.

//Identify and eliminate duplicates based on specific criteria
workItems = items

const lookup: any[] = workItems.reduce((a, e) => {
  a[e.Level] = ++a[e.Level] || 0;
  return a;
}, {});


const levels = workItems.filter(e => lookup[e.Level]);

//Determine the most recent date among duplicates and remove older instances
let isLast = levels[0];
for (let date of levels) {
  if (moment(date.YourDateField) > moment(isLast.YourDateField)) {
    isLast = date;
  }
}

Retrieve a collection of duplicate objects and choose the one with the most recent date

Answer №1

Similar questions

What is the most efficient way to find the sum of duplicates in an array based on two different properties and then return the

What impact does setting 'pathmatch: full' in Angular have on the application?

The Angulartics2GoogleAnalytics type does not have the property 'startTracking' in its definition

I'm trying to figure out the best way to successfully pass a prop to another component in TypeScript without running into the frustrating issue of not being able to

Tips for adding new data to an array in a JSON file without overwriting the existing contents

Unable to retrieve React state within the callback function

CodeIgniter throwing an error with converting Array to String?

Custom number of arrays specified by the user

Error in Compiling HTML Elements Collection<<Element>

Sequencing animations with *ngIf in Angular 6

Speedy method for declaring array elements incrementally - Java

How can I hide a mat card in Angular when the array is empty?

Enter the Angular Date Picker on Safari

Arranging numerous items based on date in JavaScript without prior knowledge

When setting properties on the Object or Array prototype in JavaScript, it disrupts the functionality of brackets

Creating a cucumber feature file from an Excel sheet or any other type of file: A step-by

ngClass with multiple conditions

Encountered an error when creating my own AngularJS module: Unable to instantiate

Click on the div in Ionic 2 to send a variable

Leveraging the Nest JS Validation Pipe in combination with the class-transformer to retrieve kebab-case query parameters