The MinMaxAvgBqlWithLimits component is used to perform mathematical analysis against a group of numeric components in the station. The array of numeric components is determined by entering a BQL query in the Point Query field.
The MinMaxAvgBqlWithLimits component is located in the vykonPro palette under the hvac sub folder. This component extends the behavior of the standard MinMaxAvgBql component, by excluding components whose values don't fall within configured limits. See the help on the MinMaxAvgBql component for the common properties.
Upper Limit - StatusNumeric property used to configure the maximum valid value for the calculation.
Lower Limit - StatusNumeric property used to configure the minimum valid value for the calculation.
Exclude Values - StatusBoolean property used to configure whether to exclude component values by comparing the value to the upper and lower limit. If the value = false ("include values"), all component values are used in the calculation. If the value = true ("exclude values"), component value must be within the upper and lower limit or it is excluded from the calculation.
Count Within Limits - Int property which displays the number of component values used in the calculation. This number may be less than the count property value if exclude values = true, and any of the component values does not fall within the upper and lower limit.
Out Of Range Zones - This property displays the number of zones whose value exceeds the configured limits. Note that the property has a workbench view assigned which displays the zone and value information in a table.
The OutOfRangeZones property has a workbench view assigned which displays a table of the zones whose current value exceeds the configured limits. The arrow icon at the right side of the field editor also provides a hyperlink to the table.
Each row in the table displays the Zone ID which is resolve based on the ZoneIdentifierFormat property. The table also displays the current value of each component. Double clicking a row in the table functions as a hyperlink to the source component. The outOfRangeZones component has a property named "Hyperlink" which is used to configure the hyperlink behavior in the table. For example assume that instead of hyperlinking to the actual component the hyperlink should go to the parent component, the property value shoudl be set to "slot:..".
The outOfRangeZones property workbench view can be embedded in a px page. There are two properties of the px widget that are useful for configuring the table behavior.
hyperlink - BOrd property which is merged with the ord of the component to determine the hyperlink when double clicking a row in the table. Setting the value to "slot:.." will result in the hyperlink directed to the parent component.
show title - Boolean property which configures whether the default view title is displayed or not.