Tuesday, April 16, 2019

SuiteScript > Search Case by customer

With SuiteScript, many of us might try to search a support case by customer using the following search filter :

var filters[0]= nlobjSearchFilter('entityid', 'customer','is', 'CustomerId'); // CustomerId is the internal id of the customer record

The above code will not work as 'entityid' is of type Text while internal id is of type Integer.

To do a joined customer search on any record using the customer record's internal id, you need to specify the following search filter :

var filters[0]= nlobjSearchFilter('internalid', 'customer','is', 'CustomerId'); // CustomerId is the internal id of the customer record

Here 'internalid' search filter and internal id of the record are both of type integer.

 

No comments:

Post a Comment