debug.js

/*the problem*/
for (let i = 0; i < recordIds.length; i++) {
    if (recordIds[i] % 2 !== 0) {
        recordIds.splice(i, 1);
    }
}

/*solution*/
function cleanDatabase(recordIds) {
    return recordIds.filter(id => id % 2 === 0);
}


const data = [1, 3, 4, 6, 7, 9, 10];
const cleaned = cleanDatabase(data);
console.log("Final List:", cleaned);

/*
The problem was caused by removing items from the array while looping through it.
This made the remaining elements shift, causing some values to be skipped.

I fixed it by using the filter() method, which avoids modifying the array during looping
and returns the correct list of even numbers.
*/