Sql+Condition+Filter Details

Element Details: Sql+Condition+Filter

Available in: Logi Info

Source code name: SqlConditionFilter

Use ActiveSQL SqlConditionFilter to return only a subset of records from a DataLayer.

A Condition (or expression) is evaluated for each row then removes rows when the result is False. The expression is written in the SQL query language of the data provider. Expressions usually contain tokens such as @Data to access specific values of each data row. Expressions can include almost any combination of tokens available in Info.

Element Group:Filter Rows

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

UserDefined

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

True

False

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"

SqlExpression

(Text)

(Required) An expression that evaluates to a value of True or False. Expressions should be in the database specific syntax. Any built in capabilities or function of the database platform are available for use within this statement. Typically, you would compare values using a token, such as "@Data.value~ < 0" or "@Session.AccountNumber~=784635". These statements are used to form the traditional WHERE clause of a SQL statement. Use single quotes when working with strings: '@Data.myColumn~' = 'SomeValue'

PARENT ELEMENTS

Click element to drill down for more information.

DataLayer.ActiveSQL

Sql Query

CHILD ELEMENTS

Click element to drill down for more information.

Sql Compare Filter