Posts

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]
Post a Comment
Read more

RSS feed of your favourite Website in Netsuite

Image
Quick setup: On the NetSuite home page dashboard, simply click the "Personalize" link and double click RSS/Atom Feed icon. Refer the screen shot below     Click "Setup" on the portlet to provide details about the feed. By default NetSuite offers feeds from Reuters, CNN, Market Watch, and others.Refer below Select the "Custom" option for the "Source" dropdown and paste/type the feed URL. Search RSS URL(your favourite website name)  You will be find out similar URL ends with .xml   Example : http://www.espncricinfo.com/rss/content/story/feeds/6.xml(Indian Cricket Fan😜) Show details check box  Check  - Will show link and short description about the link UnCheck - Will show only the link  You can also set the number of RSS links to display in the portlet and indicate whether you would like to view the feed details or just the links. Click "Save." Here you go!!!
Post a Comment
Read more