Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
SuiteScript - Search Join
Need some help how to do the Search Join (supportcase and message)
Below is my codes, Got " message is not a valid internal ID" error. Please advise what I did wrong. Thanks so much.
// Criteria
var filters = new Array();
filters[0] = new nlobjSearchFilter('casenumber', null, 'is', datain.casenumber);
filters[1] = new nlobjSearchFilter('message', 'message', null, null);
// Results
var columns = new Array();
columns[0] = new nlobjSearchColumn('company', null, null);
columns[1] = new nlobjSearchColumn('casenumber', null, null);
columns[2] = new nlobjSearchColumn('message', 'message', null, null);
columns[3] = new nlobjSearchColumn('messagedate', 'message', null);
columns[4] = new nlobjSearchColumn('messagetype', 'message', null);
var searchresults = nlapiSearchRecord('supportcase', null, filters, columns);
// Loop the results;