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
)
Public Function GenerateSubquery (
columnName As String,
dbms As DBMSType,
alias As String
) As String
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:
StringA SQL subquery appropriate for use in an IN clause.
See Also