How to Filter for Empty List/Record Fields in NetSuite Scripted Searches

To identify records where a specific list or record field is empty within a NetSuite scripted search, use the '@NONE@' value with the ANYOF or NONEOF operator. In SuiteScript 2.0, this is accomplished by creating a search filter using the search.createFilter method.

1. Ensure your SuiteScript 2.0 script loads the N/search module.

2. Construct the filter using the field's internal ID, the search.Operator.ANYOF (or NONEOF) operator, and ['@NONE@'] as the values.For example, to find records where the custrecord_fabrication_wo_linked field is empty:

javascript/** * @NApiVersion 2.x * @NModuleScope SameAccount */define(['N/search'], function(search) {    // ... your script logic ...    var emptyFieldFilter = search.createFilter({        name: 'custrecord_fabrication_wo_linked',        operator: search.Operator.ANYOF,        values: ['@NONE@']    });    // This filter can then be added to a search.create or search.load operation.    // Example:    // var mySearch = search.create({    //     type: search.Type.TRANSACTION,    //     filters: [emptyFieldFilter],    //     columns: ['internalid']    // });    // ...});

This filter effectively targets records where the specified list/record field has no value selected.