SfDataGridBehaviorFilterPredicatesToSQLFilter Method

Converts the filter predicates of the specified GridColumn and DataGrid into a SQL filter expression.

Definition

Namespace: Aliquo.Windows.Controls
Assembly: Aliquo.Windows.Controls (in Aliquo.Windows.Controls.dll) Version: 5.0.9179.22656
C#
public static string FilterPredicatesToSQLFilter(
	SfDataGrid grid,
	GridColumn column,
	List<FilterPredicate> filterPredicates = null,
	string fieldName = null,
	bool useSquareBrackets = true
)

Parameters

grid  SfDataGrid
Control SfDataGrid.
column  GridColumn
GridColumn of the SfDataGrid to process.
filterPredicates  ListFilterPredicate  (Optional)
List of filter predicates. If not specified, the predicates of the column are assumed.
fieldName  String  (Optional)
Name that is assigned as a field to the filter predicates. If not specified, assumes MappingName of the column.
useSquareBrackets  Boolean  (Optional)
Indicates whether to use square brackets in field names.

Return Value

String
String containing the SQL filter expression, or if the column is not filtered.

See Also