General Refine Expression Language

General Refine Expression Language (GREL) is a simple scripting language used in TIBCO Clarity.

GREL has built-in functions which you can use to update the cells. The following are some of the GREL functions:
  • Control
  • Arrays
  • Boolean
  • Date
  • Math
  • String
  • Others
You can call a GREL function in one of the following ways:
  • functionName(arg0, arg1, ...)
  • arg0.functionName(arg1, ...)

For each expression, you need to use a variable name. The following is the list of variable names and their description:

Variable Name Description
value It is short for cell.value and indicates the value in the current cell. The value can be null, a string, a number, a boolean or an error.
cell It is the cell object in the base column of the current row, which has only one field - cell.value.
cells It is short for row.cells and indicates the cells in the current row. You can retrieve a particular cell from cells.<column name> if the <column name> is a single word, or from cells["<column name>"] if the <column name> is not a single word.
row It is the current row object which has five different fields - 'flagged', 'starred', 'index', 'cells', and 'record'.
record It is the current record object which has different fields - 'index', 'cells', 'fromRowIndex', and 'toRowIndex'.