Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Scripting an Event search not working - HELP!
UG,
I'm attempting to to a search for Events (calendarevent) via script. I have a value being passed as a variable that is the internal ID of a customer record. So essentially, I'm just trying to find all Events that are associated with a particular customer.
Here's the code:
var eventFilters = new Array(); eventFilters[0] = new nlobjSearchFilter('attendee', null, 'is', secCustName); //this is sourcing the company text name (yes, I've tried internal ID too) var eventColumns = new Array(); eventColumns[0] = new nlobjSearchColumn('internalid', null, null); eventColumns[1] = new nlobjSearchColumn('company', null, null); var arrEventSearchResults = new Array(); arrEventSearchResults = nlapiSearchRecord('calendarevent', null, eventFilters, eventColumns); if (arrEventSearchResults == null) { continue; } for (w = 0; w < arrEventSearchResults.length; w++) { var eventSearchResults = arrEventSearchResults[w]; var eventSearchColumns = eventSearchResults.getAllColumns(); var eventId = eventSearchResults.getValue(eventSearchColumns[0]); var eventRecord = nlapiLoadRecord('calendarevent', eventId); eventRecord.setFieldValue('company', arrPriCust[c][0]); //changing the company on the Event nlapiSubmitRecord(eventRecord, false, true); } 0