The Languages of Nimblex

There are two languages in use in the eBMS Platform:

  1. The Formula language: an advanced, Excel-based data manipulation language.
  2. The Filter Expression language: an SQL-inspired language for filtering datasets and defining access rules.

These languages are very different and are used in different contexts

Formula Language

This language is inspired by Excel formulas

You may encounter this:

  • When writing a formula for an eForm data column
  • When writing a validation formula in an eForm
  • When setting up Tasks in a Scheduled Event

Usually formulas run in the context of a record, and so column names may be used e.g.: [Assignee], RecordID

Formula

Filter Language

This language is inspired by SQL

Every expression is translated directly into SQL queries to be run on a particular table or view. This allows us to operate on large data-sets efficiently, but has the trade-off that the language is somewhat restrictive in what it can do. Every function made available to the filter language must be translated to the SQL language available to the database backed.

You may encounter this:

  • In the filter editor on the left of Tabular Report and Charting Report
  • In the url of a Tabular Report link
  • Setting up permissions for an eForm
  • Setting up a Reporting Bar Chart, Pie Chart or Table
  • Setting up a Scheduled Event

To make life easier for average users, we have a graphical editor that can be used to access most functionality of the Filter language (see below).

Filter

Related Articles