Hello, I keep on getting a script error that the i...
# suitescriptp
Phillip
03/17/2021, 4:14 PMHello, I keep on getting a script error that the id is missing. I am trying to pull results from a grouped saved search. What am I doing wrong? var resultRange = searchResult.getRange({ start0,end 1000
}).forEach(function(result){
//var itemid = result.id;
var itemid = result.getValue("Internal ID");
var soid= record.load({
type: record.Type.INVOICE,
id: itemid,
isDynamic: false
});
c
creece
03/17/2021, 4:16 PM Copy code
var resultRange = searchResult.getRange({ start:0,end: 1000
}).forEach(function(result){
//var itemid = result.id;
var itemid = result.getValue({name: 'internalid'}); // Assuming 'internalid' is search column otherwise result.id should work IFF result is an Item search result.
var soid= record.load({
type: record.Type.INVOICE,
id: itemid,
isDynamic: false
}); (edited)s
Sandii
03/17/2021, 4:16 PMSpecifically, getValue does not take a string as a parameter
Sandii
03/17/2021, 4:18 PMIn general, your variable name makes no sense,
itemidsoidw
Watz
03/17/2021, 4:26 PM@creece, result.id won't work in a grouped search iirc.
s
Sandii
03/17/2021, 4:27 PMThat would make sense
w
Watz
03/17/2021, 4:30 PMYou need to add the column and set it as grouped to be able to retrieve it.
p
Phillip
03/17/2021, 4:44 PMthanks for the help. I changed it to result.getValue(result.columns[0]); and it worked
m
michoel
03/17/2021, 10:10 PMDo you need to load every record from your search results? I can see this quickly running out of governance. I'd suggest adding the fields you need to this or a second search
p
Phillip
03/17/2021, 10:21 PMwould it be possible to set the header fields and not open up the record? I have the fields I need from the search
m
michoel
03/17/2021, 10:48 PM4 Views