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

Popular posts from this blog

RSS feed of your favourite Website in Netsuite