Skip to main content
Pentaho Documentation

Script Functions

The Script category contains functions that enable you to directly type in code from a supported scripting language.

  • Bean-Scripting Framework (BSF)
  • Bean-Scripting Host (BSH)
  • JavaScript
  • Single Value Query

The only unique object Pentaho offers in Report Designer for a scripting language is getValue for the Bean-Scripting Framework, which retrieves the current record or row, as shown below:

Object getValue()
  {
  	Object value = dataRow.get("RegionVariance");
      if (value instanceof Number == false)
      {
      	return Boolean.FALSE;
      }
      Number number = (Number) value;
      if (number.doubleValue() < 0)
      {
      return Boolean.TRUE;
      }
      return Boolean.FALSE;
  }