Expression Editor
The Expression Editor is used to manage formulae (expressions). An expression can be used to calculate a value that cannot be calculated with standard MineMarket fields.
Expressions are based on functions. Functions are used to access the values of MineMarket object properties. Multiple functions can be within a single expression.
Within the Expression Editor, functions are in the following categories:
- Analyte
- Convert
- Date & Time
- Despatch Order / Despatch Dates
- Financial
- Hedging
- Invoicing
- Logical
- Mathematical
- Price Series
- Quotation Period
- Statistical
- Text
Expressions are evaluated within a context. For example, when calculating the invoice line item for a contract charge based on an expression, the functions return actual values from the applicable despatch (for example, ATA); despatch order (for example, bill of lading date, loaded wet mass); or assays.
Expressions are evaluated according to the regional settings of the machine on which they are evaluated (typically, the MineMarket Client). Within the MineMarket Service configuration, there is a setting for an expression locale. If an expression locale has been configured for the MineMarket Service:
- The name of the expression locale displays at the bottom of the Expression Editor.
- All expressions must be entered according to the conventions of the configured expression locale. A tooltip on the expression locale name displays the required decimal separator and list separator.
Dates in expressions are not impacted by the expression locale. MineMarket converts all dates to the ISO date format before evaluating the expression.
Expressions can be tested and saved to the Expression Library.
If the Expression Editor is opened via the System Admin ribbon tab, expressions can be marked as tested expressions.
Only tested expressions display in the Expression Library when the Expression Editor is opened from within a contract.
Video
A Datamine consultant recorded this video about the Expression Editor in MineMarket.
