Using Formulas in Search
Note:
Knowledge of SQL will help you to fully leverage the flexibility and power of SQL functions to define complex formulas, but NetSuite’s Formula popup windows can help you to correctly define formula expressions. These popups include a Function dropdown that allows you to select SQL functions to be included in expressions, and Filter or Field dropdowns that allow you to select field names and have their IDs included in expressions. For more details, refer to SQL Expressions. Also you can refer to SuiteScript Supported Records for tables of NetSuite field IDs.
SQL ExpressionsImportant:
This section provides some material for convenience only. It is assumed that you are familiar with the implementation of SQL expressions. For a complete reference to SQL expressions, click here (requires oracle account activation). Note that not all of the expressions described at this URL are supported in NetSuite.
NetSuite supports at least some Oracle SQL Expressions which are not in the NetSuite Help Center SQL Expressions documentation. The NetSuite SQL Expressions documentation is "for convenience only". The user is directed to Oracle documentation for a complete reference to SQL Expressions. NetSuite does not support all of the expressions documented by Oracle.Am I correct in understanding that NetSuite does not document which SQL Expressions are supported by NetSuite? Providing such documentation would seem to be more than a matter of convenience.