Demonstrates filtering by field or column values as well as multiple filters.
NOV Grid allows you to create filter rules that work on column and field provided row values. This makes it possible to create filter rules that work on calculated columns (i.e. columns that do not have an associated field in the data source) as well as create filter rules that work on data source fields, regardless of whether they are represented by columns in the grid.
In this example we have create two filter rules.
The first filter rule filters records for which the PersonId field is equal to 0. This filter rule is not associated with a column,
since the PersonId field is not represented by a column in the grid.
The second filter rule filters records for which the Total calculated column is greater than 150. This filter rule is associated with a column,
which is at the same time row value provider for this filter rule row condition. Note that the Total column does not have an associated field in the data source.

| Language: C# |
using Nevron.Nov;
using Nevron.Nov.Dom;
using Nevron.Nov.Graphics;
using Nevron.Nov.Grid;
using Nevron.Nov.Layout;
using Nevron.Nov.UI;
using Nevron.Nov.Windows.Forms;
using System;
using System.Windows.Forms;
namespace NovWinFormsProject
{
public partial class Form1 : Form
{
#region Constructors
public Form1()
{
InitializeComponent();
// Set form title
Text = "NOV WinForms - NColumnAndFieldFilteringExample";
// Create the NOV example and its controls
NWidget exampleContent = CreateExampleContent();
NWidget exampleControls = CreateExampleControls();
if (exampleControls != null)
{
exampleControls.PreferredWidth = 300;
}
// Place the example and its controls in a pair box
NPairBox pairBox = new NPairBox(exampleContent, exampleControls);
pairBox.FillMode = ENStackFillMode.First;
pairBox.FitMode = ENStackFitMode.First;
pairBox.Margins = new NMargins(NDesign.HorizontalSpacing, NDesign.VerticalSpacing);
// Host the example in the form
NNovWidgetHost host = new NNovWidgetHost(pairBox);
host.Dock = DockStyle.Fill;
Controls.Add(host);
}
#endregion
#region Example
public NWidget CreateExampleContent()
{
NTableGridView view = new NTableGridView();
NTableGrid grid = view.Grid;
// bind the grid to the data source, but exclude the "PersonId" column.
grid.AutoCreateColumn += delegate(NAutoCreateColumnEventArgs arg)
{
if (arg.FieldInfo.Name == "PersonId")
{
arg.DataColumn = null;
}
};
grid.DataSource = NDummyDataSource.CreatePersonsOrdersDataSource();
// add a custom calculated column of type Double that displays the Total (e.g. Price * Quantity)
NCustomCalculatedColumn totalColumn = new NCustomCalculatedColumn();
totalColumn.Title = "Total";
totalColumn.GetRowValueDelegate += delegate(NCustomCalculatedColumnGetRowValueArgs arg)
{
// calculate a RowValue for the RowIndex
double price = Convert.ToDouble(arg.DataSource.GetValue(arg.RowIndex, "Price"));
double quantity = Convert.ToDouble(arg.DataSource.GetValue(arg.RowIndex, "Quantity"));
return (double)(price * quantity);
};
totalColumn.Format.BackgroundFill = new NColorFill(NColor.SeaShell);
grid.Columns.Add(totalColumn);
// show only records where PersonId = "0"
// NOTE: when the rule is not associated with a column, you must explicitly specify a row value for the row condition.
NFilteringRule personIdFilterRule = new NFilteringRule();
NOperatorRowCondition rowCondition = new NOperatorRowCondition(ENRowConditionOperator.Equals, "0");
rowCondition.RowValue = new NFieldRowValue("PersonId");
personIdFilterRule.RowCondition = rowCondition;
grid.FilteringRules.Add(personIdFilterRule);
// show only records for which the total column is larger than 150
// NOTE: when the rule is associated with a column, by default the row condition operates on the column values.
NFilteringRule companyFilterRule = new NFilteringRule();
companyFilterRule.Column = totalColumn;
companyFilterRule.RowCondition = new NOperatorRowCondition(ENRowConditionOperator.GreaterThan, "150");
grid.FilteringRules.Add(companyFilterRule);
// customize the grid
grid.AllowSortColumns = true;
grid.AlternatingRows = true;
grid.RowHeaders.Visible = true;
return view;
}
public NWidget CreateExampleControls()
{
return null;
}
public string GetExampleDescription()
{
return @"
Demonstrates filtering by field or column values as well as multiple filters.
NOV Grid allows you to create filter rules that work on column and field provided row values.
This makes it possible to create filter rules that work on calculated columns (i.e. columns that do not have an associated field in the data source)
as well as create filter rules that work on data source fields, regardless of whether they are represented by columns in the grid.
In this example we have create two filter rules.
The first filter rule filters records for which the PersonId field is equal to 0. This filter rule is not associated with a column,
since the PersonId field is not represented by a column in the grid.
The second filter rule filters records for which the Total calculated column is greater than 150. This filter rule is associated with a column,
which is at the same time row value provider for this filter rule row condition. Note that the Total column does not have an associated field in the data source.
";
}
///
/// Gets the relevant documentation links for the example
///
///
public (string Name, string Url)[] GetDocumentationUrls()
{
return new[]
{
("Grid Filtering", "https://www.nevron.com/docs/openvision/grid-filtering.html"),
("Grid Row Conditions", "https://www.nevron.com/docs/openvision/grid-row-conditions.html"),
};
}
#endregion
#region Implementation
#endregion
#region Event Handlers
#endregion
#region Fields
#endregion
#region Static Methods
#endregion
#region Constants
#endregion
#region Nested Types
#endregion
}
} | Language: VB.NET |
Imports Nevron.Nov
Imports Nevron.Nov.Dom
Imports Nevron.Nov.Graphics
Imports Nevron.Nov.Grid
Imports Nevron.Nov.Layout
Imports Nevron.Nov.UI
Imports Nevron.Nov.Windows.Wpf
Imports System
Class MainWindow
#Region "Constructors"
Public Sub New()
' This call is required by the designer.
InitializeComponent()
' Add any initialization after the InitializeComponent() call.
' Set form title
Title = "NOV WPF - NColumnAndFieldFilteringExample"
' Create the NOV example and its controls
Dim exampleContent As NWidget = CreateExampleContent()
Dim exampleControls As NWidget = CreateExampleControls()
If Not exampleControls Is Nothing Then
exampleControls.PreferredWidth = 300
End If
' Place the example and its controls in a pair box
Dim pairBox As NPairBox = New NPairBox(exampleContent, exampleControls)
pairBox.FillMode = ENStackFillMode.First
pairBox.FitMode = ENStackFitMode.First
pairBox.Margins = New NMargins(NDesign.HorizontalSpacing, NDesign.VerticalSpacing)
' Host the example in the form
Dim host As NNovWidgetHost(Of NWidget) = New NNovWidgetHost(Of NWidget)(pairBox)
Content = host
End Sub
#End Region
#Region "Example"
Public Function CreateExampleContent() As NWidget
Dim view As NTableGridView = New NTableGridView()
Dim grid = view.Grid
' bind the grid to the data source, but exclude the "PersonId" column.
grid.AutoCreateColumn += Sub(arg As NAutoCreateColumnEventArgs)
If Equals(arg.FieldInfo.Name, "PersonId") Then
arg.DataColumn = Nothing
End If
End Sub
grid.DataSource = NDummyDataSource.CreatePersonsOrdersDataSource()
' add a custom calculated column of type Double that displays the Total (e.g. Price * Quantity)
Dim totalColumn As NCustomCalculatedColumn(Of Double) = New NCustomCalculatedColumn(Of Double)()
totalColumn.Title = "Total"
totalColumn.GetRowValueDelegate += Function(arg As NCustomCalculatedColumnGetRowValueArgs(Of Double))
' calculate a RowValue for the RowIndex
Dim price = Convert.ToDouble(arg.DataSource.GetValue(arg.RowIndex, "Price"))
Dim quantity = Convert.ToDouble(arg.DataSource.GetValue(arg.RowIndex, "Quantity"))
Return price * quantity
End Function
totalColumn.Format.BackgroundFill = New NColorFill(NColor.SeaShell)
grid.Columns.Add(totalColumn)
' show only records where PersonId = "0"
' NOTE: when the rule is not associated with a column, you must explicitly specify a row value for the row condition.
Dim personIdFilterRule As NFilteringRule = New NFilteringRule()
Dim rowCondition As NOperatorRowCondition = New NOperatorRowCondition(ENRowConditionOperator.Equals, "0")
rowCondition.RowValue = New NFieldRowValue("PersonId")
personIdFilterRule.RowCondition = rowCondition
grid.FilteringRules.Add(personIdFilterRule)
' show only records for which the total column is larger than 150
' NOTE: when the rule is associated with a column, by default the row condition operates on the column values.
Dim companyFilterRule As NFilteringRule = New NFilteringRule()
companyFilterRule.Column = totalColumn
companyFilterRule.RowCondition = New NOperatorRowCondition(ENRowConditionOperator.GreaterThan, "150")
grid.FilteringRules.Add(companyFilterRule)
' customize the grid
grid.AllowSortColumns = True
grid.AlternatingRows = True
grid.RowHeaders.Visible = True
Return view
End Function
Public Function CreateExampleControls() As NWidget
Return Nothing
End Function
Public Function GetExampleDescription() As String
Return "
Demonstrates filtering by field or column values as well as multiple filters.
NOV Grid allows you to create filter rules that work on column and field provided row values.
This makes it possible to create filter rules that work on calculated columns (i.e. columns that do not have an associated field in the data source)
as well as create filter rules that work on data source fields, regardless of whether they are represented by columns in the grid.
In this example we have create two filter rules.
The first filter rule filters records for which the PersonId field is equal to 0. This filter rule is not associated with a column,
since the PersonId field is not represented by a column in the grid.
The second filter rule filters records for which the Total calculated column is greater than 150. This filter rule is associated with a column,
which is at the same time row value provider for this filter rule row condition. Note that the Total column does not have an associated field in the data source.
"
End Function
'''
''' Gets the relevant documentation links for the example
'''
'''
Public Function GetDocumentationUrls() As (String, String)()
Return {("Grid Filtering", "https://www.nevron.com/docs/openvision/grid-filtering.html"), ("Grid Row Conditions", "https://www.nevron.com/docs/openvision/grid-row-conditions.html")}
End Function
#End Region
#Region "Implementation"
#End Region
#Region "Event Handlers"
#End Region
#Region "Fields"
#End Region
#Region "Static Methods"
#End Region
#Region "Constants"
#End Region
#Region "Nested Types"
#End Region
End Class