Users may encounter an unexpected error when grouping results of a scripted record search. When applying grouping to a result of a scripted search, all columns need to have summary function otherwise it is treated as an invalid search and adding groupings/summary to the rest of the columns will resolve the unexpected error.
// Sample with error
var col = new Array();
col[0] = new nlobjSearchColumn('custrecord_grade',null,'group');
col[1] = new nlobjSearchColumn('custrecord_employee');
var cust = nlapiSearchRecord('customrecord24', null, null, col);
// Sample code after fixing the above issues
var col = new Array();
col[0] = new nlobjSearchColumn('custrecord_grade',null,'group');
col[1] = new nlobjSearchColumn('custrecord_employee',null,'group');
var cust = nlapiSearchRecord('customrecord24', null, null, col);
No comments:
Post a Comment