[customfield_myfield, search.Operator.ISEMPTY, '']

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you are trying to search for records with a custom list/record field being empty. In NetSuite, the

search.Operator.ISEMPTY

operator does not work as expected for this case. Instead, you can use the

search.Operator.ANYOF

operator with a special value

@NONE@

to check if a field is empty. Here is an example:

{
    name: 'custbody_fye_booking_journal_entry',
    operator: search.Operator.ANYOF,
    values: '@NONE@',
}

This will return the records where the 'custbody_fye_booking_journal_entry' field is empty. For a datetime field, if you want a filter to say "if this date time field is empty", you can try not providing the 3rd element in your array ('') or null for that 3rd param. However, sometimes NetSuite can behave inconsistently and you might need to wait for a while before the filters work as expected. If you want to check if a field is empty in a formula, you can use a case statement like this:

Case when {field}= null then 1 else 0 end

. This will return 1 if the field is empty and 0 otherwise. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******