Use Formula Columns on SuiteScript 1.0 Searches

Jira code: TAIP-60

To get formula columns in the script for suitescript 1.0 searches.  i.e. formulatext, formulanumeric, formuladate.

var columns = new Array();
columns[0] = new nlobjSearchColumn(‘formulatext’);
columns[0].setFormula(“CASE WHEN {quantitycommitted}-{quantity}<0 THEN ‘Some Items Committed’ ELSE ‘Fully Committed’ END”) ;

Then use the below code to get value from the formula field:

result.getValue(columns[0]));