Click or drag to resize

DateFilterFilterDate Method (IAppContext, DBMSType, String, String, String, String, TimeZone, TimeZone, Boolean, String)

Builds a filter for this field as a DBMS neutural date

Namespace:  NetQuarry
Assembly:  EAP.Core (in EAP.Core.dll) Version: 2.0.0.0 (4.6.8.0)
Syntax
public static string FilterDate(
	IAppContext appCxt,
	DBMSType dbmsType,
	string colName,
	string oper,
	string text,
	string caption,
	TimeZone tzStg,
	TimeZone tzDisp,
	bool showSeconds,
	out string desc
)

Parameters

appCxt
Type: NetQuarryIAppContext
The application context.
dbmsType
Type: NetQuarryDBMSType
The database type.
colName
Type: SystemString
The field's physical column name in the underlying table.
oper
Type: SystemString
The operator string.
text
Type: SystemString
The value against which to filter.
caption
Type: SystemString
The name of the item being filtered, in a form suitable for display to the user.
tzStg
Type: NetQuarryTimeZone
The timezone of the stored date/time.
tzDisp
Type: NetQuarryTimeZone
The timezone of the data/time as displayed to the user.
showSeconds
Type: SystemBoolean
Specifies whether or not seconds are displayed to the user.
desc
Type: SystemString
The returned naturl language description corresponding to the generated filter.

Return Value

Type: String
The SQL filter clause.
See Also