Using Quality Functions

These functions operate on UInt32 Status Codes, typically returned by an operation on real-time or historical values. For the status codes returned by historical operations and their meanings, see Data Historian Status Codes.

GETDESCQ

Returns a human-readable string of the UInt32 expression representing a Status Code.

Example:

SELECT getdescq(2147483658) --returns "Bad - User Access Denied"

ISBADQ

Determines if the specified UInt32 expression represents a Bad Status Code.

Examples:

SELECT isbadq(0) --returns false SELECT isbadq(134217728) --returns true

ISGOODQ

Determines if the specified UInt32 expression represents a Good Status Code.

Examples:

SELECT isgoodq(0) --returns true SELECT isgoodq(134217728) --returns false

ISUNCQ

Determines if the specified UInt32 expression represents an Uncertain Status Code.

Examples:

SELECT isuncq(134217728) --returns false SELECT isuncq(3221225472) --returns true