is it possible to search for records with a custom...
# suitescriptn
Nicholas Penree
10/21/2021, 9:45 PMis it possible to search for records with a custom list/record field being empty? I tried search.Operator.ISEMPTY and records with a record assigned still come back. Looking at the docs, it says List/Record only allows ANYOF and NONEOF. But How would I structure the ANYOF?
Nicholas Penree
10/21/2021, 9:46 PMI tried:
Copy code
{
name: 'custbody_fye_booking_journal_entry',
operator: search.Operator.ANYOF,
values: [null],
}Nicholas Penree
10/21/2021, 9:46 PMand:
Copy code
{
name: 'custbody_fye_booking_journal_entry',
operator: search.Operator.ISEMPTY,
}Nicholas Penree
10/21/2021, 9:47 PMand:
Copy code
{
name: 'custbody_fye_booking_journal_entry',
operator: search.Operator.ANYOF,
values: [],
}m
Mike Robbins
10/21/2021, 9:48 PMI think it’s this:
Copy code
{
name: 'custbody_fye_booking_journal_entry',
operator: search.Operator.ANYOF,
values: '@NONE@',
}đź‘Ť 1
n
Nicholas Penree
10/21/2021, 9:52 PMThat did the trick, thanks
Nicholas Penree
10/21/2021, 9:52 PMWhere did you find that value if you don't mind me asking? I searched the suitescript help and couldn't find any reference of it
m
Mike Robbins
10/21/2021, 9:54 PMI tried to find it in the help just now and couldn’t find it. It’s just something that I picked up somewhere previously.
n
Nicholas Penree
10/21/2021, 9:54 PMAlright, at least I'm not crazy. Thanks again!
m
Mike Robbins
10/21/2021, 10:02 PMAlso, with this Chrome extension, you can build your search in the UI and see the SuiteScript needed to recreate that search in code. It’s very helpful.
https://chrome.google.com/webstore/detail/netsuite-search-export/gglbgdfbkaelbjpjkiepdmfaihdokglp?hl=en-US
n
Nicholas Penree
10/21/2021, 10:02 PMAwesome, thanks again
20 Views