|
| CaseSensitive | | Set CaseSensitive to "False" when comparing and matching values regardless of character case.
For elements using DataLayer.ActiveSQL, CaseSensitive may be set to "DataSourceCollation". Then case sensitivity is defined by the database column's "collation" which may be sensitive or not. This option can provide better performance for case-insensitive filters.
For AnalysisFilter with DataLayer.ActiveSQL and SqlCompareFilter, the default is "DataSourceCollation". The default is "True" for all other elements. |
| ColumnName | | (Required) The name of a column in the table. |
| CompareType | | NotEqual |
| LessThanOrEqual |
| LessThan |
| GreaterThanOrEqual |
| GreaterThan |
| Equal |
| (Required) Defines the type of comparison to perform. |
| CompareValue | | (Required) The value to use in the comparison.
When working with dates, to ensure they are not in an ambiguous format, specify values in y-m-d order. |
| DataType | | Specifies the type of data present. |
| ExceptionDataID | | Defines an ETL ID value that can be used to address the exception data that was removed by the filter.
The value of this attribute may be referenced by a DataLayer.ETL, LoadDbTable, SaveData, or any other element that supports the EtlElementID attribute. |
| ID | | (Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition. |
| IncludeCondition | | An expression that evaluates to a value of True or False. If the expression is blank, or evaluates to true the element is processed. If the expression evaluates to false, the element is skipped.
Expressions should be in VBScript or JavaScript syntax. For .NET versions, the scripting language can be set in the _settings.lgx General element. For Java versions, the scripting language is always JavaScript.
Typically, you would compare values using an operator, such as "@Session.value~ < 0".
Use quotes when working with strings:
"@Session.myValue~" == "SomeValue"
|