DataFilterCollection.ConjunctionMode Property
Gets or sets the conjunction mode for filter conditions defined by the collection’s items.
Namespace: DevExpress.XtraCharts
Assembly: DevExpress.XtraCharts.v22.2.dll
NuGet Package: DevExpress.Charts
Declaration
Property Value
Type | Description |
---|---|
ConjunctionTypes | A ConjunctionTypes enumeration value. |
Available values:
Name | Description |
---|---|
And | Identifies the AND conjunction operator. |
Or | Identifies the OR conjunction operator. |
Remarks
The ConjunctionMode property specifies how the filter conditions which are defined by the collection items (namely, by instances of the DataFilter class) are combined in order to form the resulting filter criterion which is applied to the corresponding series.
Example
The following example demonstrates how to create DataFilter objects, and apply their conditions to a series at runtime. For more information, refer to Filtering Data.
For this example to work correctly, a chart should contain at least one series, which is bound to the “Categories” data table in the Northwind Traders database (nwind.mdb file shipped with the XtraCharts demo). Please refer to the following tutorial to see how to bind a series to data: How to: Bind Individual Chart Series to Data (Runtime Sample).
The code below creates and applies the following filter to series data: “CategoryID = 1 or CategoryID = 4 or CategoryID = 7”
using DevExpress.XtraCharts;
// ...
// Create new data filters and specify conditions for them.
DataFilter dataFilter1 = new DataFilter("CategoryID", "System.Int32", DataFilterCondition.Equal, 1);
DataFilter dataFilter2 = new DataFilter("CategoryID", "System.Int32", DataFilterCondition.Equal, 4);
DataFilter dataFilter3 = new DataFilter("CategoryID", "System.Int32", DataFilterCondition.Equal, 7);
// Obtain the first series of the chart.
Series series1 = chartControl1.Series[0];
// Set the logical operator used to combine individual data filter conditions for this series.
series1.DataFiltersConjunctionMode = ConjunctionTypes.Or;
// Remove all other filters.
series1.DataFilters.Clear();
// Add new filters to apply to the series data.
series1.DataFilters.AddRange(new DataFilter[] {dataFilter1, dataFilter2, dataFilter3});