Formulas

Not Rated Yet

There are a number of places in Online Mooring where we calculate values by evaluating a configured T-SQL expression.  These formulas are used to calculate the fees that should be charged, and to calculate dates when things should start/stop.

The formulas are in the form of a T-SQL expression, and any valid T-SQL expression is allowed.  This expression can reference any of the fields in the objects specified in the table below, which varies based on which type of calculation is being performed.  This expression can also include some non-standard T-SQL syntax, which is in the form of tags (in the form of #tagname#) that get replaced with values from the database prior to executing the T-SQL expression.

At the moment, tag recursion is only partly supported.  This means that things may not work if you specify a tag that ends up getting replaced with another similar tag.  For example, if you wanted the FeeFormula for a Renewal Submitted action to be the same as the FeeFormula for the Application Submitted action, and the FeeFormula for the Application Submitted action specified to use the FeeFormula for the Wait List Submitted action, it wouldn't work.  The expression passed to SQL would be the formula exactly as it appears on the Application Submitted action.

We replace the tags in the order shown in this grid below.  This means that if the tags in one row end up getting replaced with tags from any other row further down in the table, it'll be fine.  But if the tag ends up getting replaced with a tag from that same row or one further up in the table, it won't get replaced.