[matthewjiang]

A basic question: when I search something in inventory numbers record, I defined filter like this:

​ var filter = new nlobjSearchFilter(‘item’, null, ‘is’, ‘3966’);

​It run good. ‘item’ is the internal id of this record.

But there are following situations:

​1) When I change value to nothing, like this:

var filter = new nlobjSearchFilter(‘item’, null, ‘is’, ”);

there’s a ‘SSS_INVALID_SRCH_OPERATOR’ error message.

​2) When I change value to something with letters, like this:

var filter = new nlobjSearchFilter(‘item’, null, ‘is’, ‘abc’);

there’s a 1000 results.

​Why does that happen? How to handle empty value. Currently I use an impossible number like ‘-99999999’ to avoid error.

Thanks a lot.
This is a cached copy. Click here to see the original post.

[michoel]

Use nlobjSearchFilter(‘item’, null, ‘is’, ”@NONE@”);

https://system.netsuite.com/app/help…_N3004217.html

[matthewjiang]

Thanks Michoel. It works.

[Author]

Posts