User-defined validation rules

User-defined validation rules always return a true or false result. You specify whether True indicates a warning or a failure. False always indicates a pass.

You can create user-defined validation rules in either of the following ways:

  • Enter a new formula when you create the validation rule.

  • Assign an existing named formula to a validation set. Named Formulas are identified by unique names (such as "MyNewValidationCheck"). For more information about named formulas, see Named formulas.

Formulas must comply with the IEE Universal Calculation Engine (UCE) syntax. For more information, see Universal calculation engine.

User-defined validation rules can be incorporated into formulas for aggregating both static and dynamic groups of service point channels. For more information on creating formulas, see Using the formula builder to configure an advanced formula.

User-defined validation rules can use the following components:

  • Simple and complex mathematical functions

  • Nested conditional statements

  • Unit conversion functions

  • Date, time, and TOU functions

  • Historical time references

  • Constants and formula constants

  • Unit conversions

  • References to additional channels

The following example illustrates the way a user-defined rule could look:

If the data in channel 00200:11 is greater than 600, then

If channel AH:11 has a value greater than 647.24, then fail the rule,

Otherwise, pass the rule,

Otherwise, return the value '10.'

The UCE formula for the above rule could look like the following:

@if (0200:11.600,@if(AH:11>647.24, 0, 1), 1)