Click or drag to resize

SavedFilterGenerateSubquery Method (String, DBMSType, String)

Generate a subquery for this filter appropriate for use in a SQL IN clause.

Namespace:  NetQuarry
Assembly:  EAP.Core (in EAP.Core.dll) Version: 2.0.0.0 (4.6.8.0)
Syntax
public string GenerateSubquery(
	string columnName,
	DBMSType dbms,
	string alias
)

Parameters

columnName
Type: SystemString
The name of the column to return. Note that the DISTINCT keyword is always used.
dbms
Type: NetQuarryDBMSType
The DBMS for which to generate the SQL.
alias
Type: SystemString
The alias, if any, to use for the selected column.

Return Value

Type: String
A SQL subquery appropriate for use in an IN clause.
See Also