This topic describes the operators that can be used to manipulate values in logical fields.
When you enter anything in the Criteria cell or the Or cell, the is equal to (=) operator is assumed at the beginning of the text unless a different operator is specified. For example, if you enter 'Y' in the Criteria cell of a logical field, GE Digital APM will assume that you want to return records where the value in that field is equal to true.
It is not necessary to enter the = operator at the beginning of the expression in a given cell. If you do not enter the operator, GE Digital APM will insert it automatically, but it will not be displayed. In addition, GE Digital APM inserts but does not display the text WHERE or HAVING before the beginning operator (either an implied = operator or an explicit alternate operator). This means that the SQL code will contain either a WHERE clause or a HAVING clause as a result of the text that you enter in the Criteria cell or the Or cell.
The following table provides examples of operators that you can use to manipulate values returned in logical fields.
Purpose | Operator | Example | Outcome of Example |
---|---|---|---|
Return records that have an exact value in a given field. | = | ='Y'' | Returns records where the field value is True. |
Return records that do not contain any values in a given field. | Is Null | Is Null | Returns records where the field is empty. |
Return records that do not have a specified value in a given field. |
Not <> != |
Not 'Y' <> 'Y' != 'Y' |
Returns records where the field value is not True (i.e., False or Null). |
Copyright © 2018 General Electric Company. All rights reserved.