Outline

Scripting Engine is a script parser engine which parses script expressions in a string. A script expression can be placed in any text-field in the Business Analyze Analysis module.

Learning Scripting Engine is part of the Advanced Training course.

Anatomy

The anatomy of a scripting engine expression is as follows:

=[function]([functionInput]);

[function] is the type of Scripting Engine function
[functionInput] is the input variables/properties you want to provide for the function to parse
These functions has either:

• Simple/single input which is a single value
• Complex input which is multiple properties formatted as JSON style Property/Value pairs:

{"PropertyName1": "Value1", "PropertyName2": "Value2"}

Usage

A script expression can be a part of a sentence:

Good morning, =u(fullname);. How are you?

A script expression can be nested:

=l(month=eval(var m =new Date().getMonth()+1; m<10 ? '0'+m : '' + m););

A string can contain numerous script expressions:

Current logged on user is =u(fullname); which uses locale =u(locale);

A script expression can reference row data by column reference:

=eval([soldAmount]*5);

Build, debug and test your expressions

The Analyze PRO platform comes with a Scripting Engine Expression tester page where you can build and test your expressions.
This interface you will find in System Administration -> Analyze Dashboard -> Scripting Engine expression tester

Functions