Jason
12/20/2023, 6:34 PM{"type":"error.SuiteScriptError","name":"SSS_MISSING_REQD_ARGUMENT","message":"Sublist.setSublistValue: Missing a required argument: options.id","id":null,"stack":["Error"," at /SuiteScripts/extensions/sl_saved_search_result.js:75:33"," at Array.forEach (native)"," at /SuiteScripts/extensions/sl_saved_search_result.js:74:29"," at postFunction (/SuiteScripts/extensions/sl_saved_search_result.js:73:30)"," at Object.onRequest (/SuiteScripts/extensions/sl_saved_search_result.js:11:17)"],"cause":{"name":"SSS_MISSING_REQD_ARGUMENT","message":"Sublist.setSublistValue: Missing a required argument: options.id"},"notifyOff":false,"userFacing":true}
const form = serverWidget.createForm({
title: 'Saved Search Results'
});
const savedSearch = search.load({
id: searchId
});
const searchResult = savedSearch.run();
let sublist = form.addSublist({
id: 'custpage_results',
type: serverWidget.SublistType.LIST,
label: 'Search Results'
});
const columns = searchResult.columns;
columns.forEach(column => {
sublist.addField({
id: column.name,
type: serverWidget.FieldType.TEXT,
label: column.label
});
});
let lineCount = 0;
searchResult.each(result => {
columns.forEach(column => {
sublist.setSublistValue({
sublistId: 'custpage_results',
fieldId: column.name,
line: lineCount,
value: result.getValue(column)
});
});
lineCount++;
});
context.response.writePage(form);erictgrubaugh
12/20/2023, 6:41 PMLIST
is not what the type of sublist you want:
This type of sublist has a fixed number of lines. You can update an existing line, but you cannot add lines to it.
battk
12/20/2023, 7:11 PMbattk
12/20/2023, 7:12 PMbattk
12/20/2023, 7:12 PMJason
12/21/2023, 2:32 PMJason
12/21/2023, 2:33 PMJason
12/21/2023, 2:34 PM