Thursday, February 28, 2019

Join Search Script using T and True filters that return different number of Results

Opportunity Saved Search on the NetSuite UI with the following criteria below returns three records on the Results page when run on a test account.

The equivalent script for this is seen below. However, it is returning a different number of records when results are seen which is fourteen.


This is caused by the value on the 4th parameter of the nlobjSearchFilter API. Changing the value from true to 'T' on the line number 3 on the code above will resolve the concern and it should return the same number of records when results are seen.

filters[0] = new nlobjSearchFilter('isinactive', 'salesrep', 'is', 'T'); 

No comments:

Post a Comment