USING CASE (IF AND ELSE) IN NETSUITE SAVED SEARCH- NETSUITE ACADEMY

While creating a saved search in Netsuite, you want encounter a situation where you want have to display a value depending on some conditions. Such scenarios can be implemented by using sql CASE syntax in the formula field. For eg, in a transaction search, if you want to display a value depending on the transaction type, then you can add a formula text field in coulmn and use CASE as given below:


CASE WHEN {type}='Invoice' THEN '0'
WHEN {type}='Journal' THEN {status}
 ELSE '' END

The above field will display 0 when type is Invoice. It will display status of the transaction when type is Journal and for other transaction type, it will be blank.


NETSUITE ACADEMY
contact us at:
Email : info@smilingcoders.com

Comments

Popular posts from this blog

Calling User Event Script from another User Event

Work Around the 1000 Row Limit Returned by Saved Searches in Netsuite