|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.|
|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.
Typically, you would compare values using an operator, such as "@Session.value~ < 0".
Use quotes when working with strings:
"@Session.myValue~" == "SomeValue"