Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Filter Expressions
I have what to me seems rather odd. Lets say I want to do a regular expression type search on an itemid. The following works fine
nlapiSearchRecord('item',null,[ ["formulanumeric: REGEXP_INSTR({itemid},'^TY.0401.0.(CST|CCT)')","greaterthan","0")]])
however the following does not and throws SSS_INVALID_SRCH_FILTER_EXPR_OBJ_TYPE
var strRegEx = "^TY.0401.0.(CST|CCT)";
nlapiSearchRecord('item',null,[ ["formulanumeric: REGEXP_INSTR({itemid},'" + strRegEx + '","greaterthan","0")]]);
I need to build the regular expression dynamically and I can't see why a concatenated string passed as the first parameter of the filter expression produces a different result.
0