netsuiteExploiting formula columns in saved searches

Introduction

Formula columns in saved searches can exploit many features of Oracle SQL and HTML. The examples show how these features can be used, as well as pitfalls to avoid.

Build a complex string by concatenating multiple fields
Complex, real-world-like example
Count records with with and without a value provided in a field (count missing and non-missing values)
Customize the CSS (stylesheet) for a column by inserting a DIV element
Oracle SQL CASE statement in a Netsuite formula
Parsing a hierarchical record name using a regular expression
Protect field values from corruption when passing through a URL
Protect string formulas from corruption and injection attacks
Test the value of `mainline` in an SQL CASE statement

PDF - Download netsuite for free

Previous Next

This modified text is an extract of the original Stack Overflow Documentation created by following contributors and released under CC BY-SA 3.0

This website is not affiliated with Stack Overflow

netsuite

netsuiteExploiting formula columns in saved searches

Introduction

Exploiting formula columns in saved searches Related Examples