FormulaNumeric REGEXP_INSTR Filter in Saved Search in Netsuite Suite Script 2.0
How to add a formulanumeric in filter is shown below.
REGEXP_INSTR syntax is below,
REGEXP_INSTR( string, pattern [, start_position [, nth_appearance [, return_option [, match_parameter [, sub_expression ] ] ] ] ] )
How to use in Saved search is shown below
search.create({
type: licensedProductRecordType,
columns: [
{name: 'internalid'}
],
filters: [['custrecord_licenseproduct_prodstatus', 'noneof', licPassiveStatus],
'and', ['custrecord_licenseproduct_jwt', 'isempty', null],
'and', ['isinactive', 'is', 'F'],
'and', ['custrecord_licenseproduct_licenseid', 'isnotempty', null],
'and', ["formulanumeric : REGEXP_INSTR({custrecord_licenseproduct_licenseid},'^\\d{16,16}$')",'notequalto',0]
]
});
Comments
Post a Comment