Negation in search filter expressions (on internal id field match) do not seem to work when run in user event scripts but work when run via a client script.
Client Script Result:
search_results_1[9127477] (should be same id) 9127477 search_results_2[9127477] (should be null) null
User Event Script Result:search_results_1[9127477] (should be same id) 9127477 search_results_2[9127477] (should be null) 9127477
function testSearchFilterNegation(sales_order_id) { var sales_order = nlapiLoadRecord('salesorder', sales_order_id); var search_filters_1 = [ ['mainline', 'is', 'T'], 'and', ['entity', 'is', sales_order.getFieldValue('entity')], 'and', ['internalid', 'is', sales_order.getId()] ]; var search_results_1 = nlapiSearchRecord('salesorder', null, search_filters_1, [ new nlobjSearchColumn('internalid') ]); if(typeof window.console === 'undefined') nlapiLogExecution('DEBUG', 'search_results_1[' + sales_order.getId() + '] (should be same id)', (search_results_1 ? search_results_1[0].getValue('internalid') : null)); else console.log('search_results_1[' + sales_order.getId() + '] (should be same id)', (search_results_1 ? search_results_1[0].getValue('internalid') : null)); var search_filters_2 = [ ['mainline', 'is', 'T'], 'and', ['entity', 'is', sales_order.getFieldValue('entity')], 'and', 'not', ['internalid', 'is', sales_order.getId()] ]; var search_results_2 = nlapiSearchRecord('salesorder', null, search_filters_2, [ new nlobjSearchColumn('internalid') ]); if(typeof window.console === 'undefined') nlapiLogExecution('DEBUG', 'search_results_2[' + sales_order.getId() + '] (should be null)', (search_results_2 ? search_results_2[0].getValue('internalid') : null)); else console.log('search_results_2[' + sales_order.getId() + '] (should be null)', (search_results_2 ? search_results_2[0].getValue('internalid') : null)); } If you run the code in firebug (or within a form/client script) the search will correctly result 0 results when using the negation ( 'and', 'not', ['internalid', 'is', sales_order.getId()]). If you run it in an After Submit user event script the search will return 1 result that has the same internalId as the negated criteria.Any ideas appreciated, thanks! PS: I have tried casting the sales order id to both an integer and a string - same result.