|
| 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. |
| ColumnNames | | (Required) A list of column names, separated by commas. For example:
OrderID, CustomerID, EmployeeID, OrderDate |
| CompareType | | NotEqual |
| LessThanOrEqual |
| LessThan |
| GreaterThanOrEqual |
| GreaterThan |
| Equal |
| Defines the type of comparison to perform. |
| DataType | | Specifies the type of data present. |
| DefaultColumnValue | | The default value to use if the column does not contain value. |
| 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. |
| NewColumnNames | | A list of column names, separated by commas. The number of items in this list must match the number in the ColumnNames attribute.
For example:
OrderID, CustomerID, EmployeeID, OrderDate |
| NewValue | | A new string value. |
| TargetValue | | The string value to seach for. |