I have a search that returns multiple values from ...
# suitescript
p
I have a search that returns multiple values from different custom records. I would like to add all of the values found into 1 text area box in a sales order. I know the search is finding all of the values from the custom records but it is only adding 1 value. How can I have it add all of the values into the field?
Copy code
var salesorder= recCurrent.getValue({fieldId: 'id'});
        var s = search.create({
            type: "salesorder",
            filters:
            [
               ["type","anyof","SalesOrd"], 
               "AND", 
               ["mainline","is","T"], 
               "AND", 
               ["internalid","anyof",salesorder]
            ],
            columns:
            [
                search.createColumn({
                    name: "custrecord_license_number",
                    join: "CUSTRECORD230",
                    summary: "GROUP",
                 })
            ]
        });
        var pagedData = s.runPaged({pageSize: 1000});
        for( var i=0; i < pagedData.pageRanges.length; i++ ) {
            var currentPage = pagedData.fetch(i);
            currentPage.data.forEach( function(result) {
            var licenseNumbers = result.getValue({ name: "custrecord_license_number", join: "CUSTRECORD230", summary: "GROUP"});
            console.log("License Numbers are " + licenseNumbers)
            recCurrent.setValue({ fieldId: 'custbody_all_license_numbers', value: licenseNumbers});
        });
        }