Table of Contents

Class SqlFilterDef

Namespace
Tripous.Data
Assembly
Tripous.Data.dll

Describes a filter applied to a Field.

The field could be a DataColumn in a DataView or a field in a SELECT statement text.

It can be used to construct the RowFilter or to construct the WHERE clause of a SELECT statement.

public class SqlFilterDef : BaseDef, IDef, IJsonLoadable, INotifyPropertyChanged
Inheritance
SqlFilterDef
Implements
Inherited Members
Extension Methods

Constructors

SqlFilterDef()

Initializes a new instance of the SqlFilterDef class.

public SqlFilterDef()

Properties

BoolOp

Gets or sets the logical boolean operator linking this expression component to adjacent conditions.

public BoolOp BoolOp { get; set; }

Property Value

BoolOp

ConditionOp

Gets or sets the query conditional evaluation comparison operator indicator token.

public ConditionOp ConditionOp { get; set; }

Property Value

ConditionOp

DataType

Gets the CLR type representation mapped directly from internal classification flags rules.

[JsonIgnore]
public Type DataType { get; }

Property Value

Type

FieldName

Gets or sets the literal target data column database identifier property field title string name.

public string FieldName { get; set; }

Property Value

string

FilterDataType

Gets or sets the structural evaluation data classification rules defined for filter calculations.

public DataFieldType FilterDataType { get; set; }

Property Value

DataFieldType

Value

Gets or sets the primary raw condition argument data token instance applied to queries.

[JsonIgnore]
public object Value { get; set; }

Property Value

object

Value2

Gets or sets the secondary boundary condition argument data token instance applied to range queries.

[JsonIgnore]
public object Value2 { get; set; }

Property Value

object

Value2Text

Gets or sets the culture-invariant serialized text token mapping for the secondary boundary argument value.

public string Value2Text { get; set; }

Property Value

string

Value2Type

Gets or sets the target assembly-qualified runtime CLR object identifier class name string for secondary boundary parsing rules.

public string Value2Type { get; set; }

Property Value

string

ValueText

Gets or sets the culture-invariant serialized text token mapping for the primary filtering argument value.

public string ValueText { get; set; }

Property Value

string

ValueType

Gets or sets the target assembly-qualified runtime CLR object identifier class name string for primary value parsing rules.

public string ValueType { get; set; }

Property Value

string

Methods

CheckDescriptor()

Validates core structural configuration properties of this operational descriptor block.

public override void CheckDescriptor()

CheckDescriptorWithValues()

Validates core properties structural attributes along with runtime value presence states matching operation tokens.

public void CheckDescriptorWithValues()