Generate a SQL filter clause for a field with a picklist. Note that if the filter is a NULL or NOT NULL filter, that is handled elsewhere and this method not called.

Namespace: NetQuarry.Data
Assembly: EAP.Mapper (in EAP.Mapper.dll) Version: 2.0.0.0 (4.6.8.0)

Syntax

Copy

protected string FilterPicklist(
	string sColName,
	string sOp,
	string sVal,
	FieldFilterFlags flags,
	out string desc,
	out bool ignorePicklist
)

Protected Function FilterPicklist ( 
	sColName As String,
	sOp As String,
	sVal As String,
	flags As FieldFilterFlags,
	<OutAttribute> ByRef desc As String,
	<OutAttribute> ByRef ignorePicklist As Boolean
) As String

Parameters

sColName: Type: SystemString
The field's physical column name in the underlying table.
sOp: Type: SystemString
The operator string.
sVal: Type: SystemString
The value against which to filter.
flags: Type: NetQuarry.DataFieldFilterFlags
Filter flags affecting filter generation.
desc: Type: SystemString
The returned naturl language description corresponding to the generated filter.
ignorePicklist: Type: SystemBoolean
Typically false, but there are times when the picklist should be ignored.

Return Value

Type: String
The SQL filter clause.

Reference

FieldKernel Class

NetQuarry.Data Namespace

FieldKernelAddLanguageSpecificTextSet("LSTB4E198D1_0?cpp=::|nu=.");FilterPicklist Method

Parameters

Return Value

Reference

FieldKernelFilterPicklist Method