Leveraging an Array of Objects in JavaScript

Question

Leveraging an Array of Objects in JavaScript

Need help with my JavaScript code! I want to adjust the date in a Date object by adding specific days and then save it. Here is what I have so far:

let orderIdDateCorrectionDict = [ 
    { "orderId": "2020053100", "dayCorrection": -146 }, 
    { "orderId": "2020053109", "dayCorrection": -146 },
    { "orderId": "2020053100", "dayCorrection": -146 },
];

migrateUp(db.Orders);
var index = 0;

function migrateUp(targetCollection) {

    targetCollection.find({
        OrderId: { $in: orderIdDateCorrectionDict.map(i => i.orderId) }
    }).forEach(
        function (order) {

            order.TransDate.DateTime = order.TransDate.DateTime.addDays(orderIdDateCorrectionDict[index++].dayCorrection);
            order.TransDate.Ticks = NumberLong((order.TransDate.DateTime.getTime() * 10000) + 621355968000000000);

            targetCollection.save(order);
        }
    );
};

Date.prototype.addDays = function (days) {
    var date = new Date(this.valueOf());
    date.setDate(date.getDate() + days);
    return date;
}

I'm encountering this error:

{ "message" : "Cannot read property 'dayCorrection' of undefined", "stack" : "script:9478:126" + "script:14:70" + "script:14:70" + "script:9475:8" + "script:9460:1" }

What adjustments should I make to update the records correctly with the day integer value?

javascript mongodb

Answer 1

Answer №1

The issue indicates that there may be duplicate order IDs within the dataset. This causes the find function to return more orders than there are entries in orderIdDateCorrectionDict, leading to the index going beyond the array's end and resulting in an undefined value ("cannot read property ... of undefined").

To troubleshoot, ensure that querying N number of IDs returns exactly N orders. Any deviation suggests non-unique IDs, requiring a fix where these duplicates originate.

To prevent this problem in the OP code regardless of how the IDs are structured, avoid using a parallel index counter. Instead, retrieve the correction by orderId like so:

function orderCorrectionForId(orderId) {
  return orderIdDateCorrectionDict.find(oc => oc.orderId === orderId)
}

// Eliminate the need for the index variable
// inside the forEach loop...

function (order) {
  let correction = orderCorrectionForId(order.OrderId)
  if (correction) {
    order.TransDate.DateTime = order.TransDate.DateTime.addDays(correction.dayCorrection);
    // continue as necessary...
  }

Initially, start by logging the order in the forEach function to pinpoint the root issue – unexpected query results.

Answer 2

The issue indicates that there may be duplicate order IDs within the dataset. This causes the find function to return more orders than there are entries in orderIdDateCorrectionDict, leading to the index going beyond the array's end and resulting in an undefined value ("cannot read property ... of undefined").

To troubleshoot, ensure that querying N number of IDs returns exactly N orders. Any deviation suggests non-unique IDs, requiring a fix where these duplicates originate.

To prevent this problem in the OP code regardless of how the IDs are structured, avoid using a parallel index counter. Instead, retrieve the correction by orderId like so:

function orderCorrectionForId(orderId) {
  return orderIdDateCorrectionDict.find(oc => oc.orderId === orderId)
}

// Eliminate the need for the index variable
// inside the forEach loop...

function (order) {
  let correction = orderCorrectionForId(order.OrderId)
  if (correction) {
    order.TransDate.DateTime = order.TransDate.DateTime.addDays(correction.dayCorrection);
    // continue as necessary...
  }

Initially, start by logging the order in the forEach function to pinpoint the root issue – unexpected query results.

Leveraging an Array of Objects in JavaScript

Answer №1

Similar questions

Issues with the Textarea StartsWith Function Being Unresponsive

Accessing/Storing Pictures in MongoDB using Mongoose

What is the best way to obtain the output of the MULTIPLO.SUPERIOR function using JavaScript?

Pagination activates on the second tap

Unique validation feature implemented in Parsley.js runs through validation loop twice

The component <FormControl /> does not support the variant prop

Transforming conversion code snippet from jQuery to Dojo - utilizing AJAX techniques

Sorting a collection of objects into separate arrays

Create an Oval-Shaped Image Cutout

React- The Autocomplete/Textfield component is not displaying properly because it has exceeded the maximum update depth limit

What is the best way to assign the result of a promise to a variable?

Is it possible to use jQuery/JS to automatically format currency input as it is typed, adding a 1000 separator and ensuring

I am attempting to display films within a watchlist module, however it is not allowing me to do so

Is it possible to integrate Wavify with React for a seamless user experience?

jQuery - accessing a different class within the object

Can a Vue component in SFC form be utilized as a mixin?

Rendering issues arise in the app when utilizing browserHistory instead of hashHistory with React Router

Hide the scroll bar in html/css while keeping the functionality of the arrows intact

What is the best way to ensure the alignment of list content and numbering remains separate in HTML while using list-style-position set to inside?

Why are the elements not found by their id when I check them, even though they were created dynamically using an ajax-generated form with php-inserted values through a