Use NVL in JavaScript
NVL (replace null value function) lets you replace a null (returned as a blank) with a string in the results of a query.
Select Compatibility mode and use the following code to replace the value of fieldName with the value of 1
, if fieldName is null:
var a;
if ( fieldname.isNull() )
{
a = '0';
}
else
{
a = fieldName.getString();
}
You can also use:
fieldName.nvl('1');
Last updated
Was this helpful?