SelectNode.FilterString Property
Specifies the criteria used to filter data returned by the node.
Namespace: DevExpress.DataAccess.DataFederation
Assembly: DevExpress.DataAccess.v23.2.dll
NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap
Declaration
Property Value
Type | Default | Description |
---|---|---|
String | null | A string that is the filter criteria. |
Remarks
The FilterString property allows you to apply a filter to the data returned by the SelectNode.
The following example filters the Orders table by the Seafood category. The CategoryName value is defined as a parameter cat - the ? sign precedes the parameter name. The parameter value is specified in the FederationDataSource.Fill(String[]) method call.
Example
This code snippet demonstrates how to create a federated data source that uses a filter with a parameter.
Note
The complete sample project How to Create a Federated Data Source at Runtime is available in the DevExpress Examples repository.
using DevExpress.DataAccess.DataFederation;
// ...
FederationDataSource federation = new FederationDataSource();
Source source = new Source("excelSource", CreateExcelDataSource("SalesPerson.xlsx", "Data"));
var sourceNode = new SourceNode(source, "Orders");
var query = new SelectNode(sourceNode)
{
Alias = "excel",
Expressions = {
new SelectColumnExpression(sourceNode, "OrderID"),
new SelectColumnExpression(sourceNode, "OrderDate"),
new SelectColumnExpression(sourceNode, "Sales Person"),
new SelectColumnExpression(sourceNode, "ProductName"),
new SelectColumnExpression(sourceNode, "Extended Price")
},
FilterString = "[Orders.CategoryName] = ?cat",
};
federation.Queries.Add(query);
federation.Fill(new[] {
new DevExpress.DataAccess.Sql.QueryParameter("cat", typeof(string), "Seafood") });