If you want to create an expression on the Spared field to return records where the check box is selected (the value is True), the expression would be:
WHERE [Asset].[ASSET SPRD IND] = 'Y'
This topic contains syntax suggestions and requirements for expressions on logical fields, as well as details about how GE Digital APM reformats expressions on logical fields.
A logical field represents a value of True or False. When you create an expression for a logical field, the exact syntax to use is either 'Y' (True) or 'N' (False).
If you want to create an expression on the Spared field to return records where the check box is selected (the value is True), the expression would be:
WHERE [Asset].[ASSET SPRD IND] = 'Y'
Some common syntax options that GE Digital APM will reformat to match the syntax required for logical fields are:
Copyright © 2018 General Electric Company. All rights reserved.