This topic contains 2 replies, has 0 voices, and was last updated by matthewjiang 7 years, 9 months ago.

  • Author
    Posts
  • #5964 Score: 0

    matthewjiang
    • Contributions: 0
    • Level 1

    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.

  • #5965 Score: 0

    michoel
    • Contributions: 0
    • Level 1

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

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

  • #5966 Score: 0

    matthewjiang
    • Contributions: 0
    • Level 1

    Thanks Michoel. It works.

You must be logged in to reply to this topic.