why findSublistLineWithValue returns -1 when 10000 or more lines is returned?

AI generated answer (using internal Slack threads):

The

findSublistLineWithValue

function in SuiteScript returns -1 when it cannot find a sublist line with the specified value. This can happen when the sublist has 10,000 or more lines because NetSuite has a limitation of 10,000 lines for sublist operations. When you have more than 10,000 lines, you need to split the lines across multiple operations or records. This is because NetSuite's sublist operations, including

findSublistLineWithValue

, are designed to handle up to 10,000 lines only. If you try to use

findSublistLineWithValue

on a sublist with more than 10,000 lines, it may not be able to find the specified value, even if it exists in the sublist, because it can only process up to 10,000 lines. As a result, it returns -1, indicating that it could not find the specified value. Here is a code snippet from the conversation that shows how to split the lines across multiple operations:

javascript
// Split the lines across multiple operations
let accumulator = [];
let count = 0;

for (let i = 0; i < sublist.length; i++) {
    accumulator.push(sublist[i]);
    count++;

    if (count === 10000) {
        // Process the accumulator
        processLines(accumulator);

        // Reset the accumulator and count
        accumulator = [];
        count = 0;
    }
}

// Process the remaining lines in the accumulator
if (accumulator.length > 0) {
    processLines(accumulator);
}

In this code,

processLines

is a function that processes up to 10,000 lines at a time. It could use

findSublistLineWithValue

or any other sublist operation. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******