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.