ASPxGridBase.FilterExpression Property

Gets or sets the filter criterion which is applied to the grid.

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v19.2.dll

Declaration

C#

[DefaultValue("")]
public string FilterExpression { get; set; }

VB.NET

<DefaultValue("")>
Public Property FilterExpression As String

Property Value

Type	Default	Description
String	String.Empty	A String value that specifies the filter criterion.

Remarks

Concept

• ASPxGridView - Filtering
• Criteria Language Syntax
• Criteria Operators

Examples

The following examples illustrate different scenarios on how to filter the grid data.

• Filter data by dates.

  C#

  DateTime date1 = new DateTime(1995, 1, 1);
  DateTime date2 = new DateTime(1995, 7, 1);
  string filter = String.Format("[OrderDate] > #{0}# And [OrderDate] < #{1}#",
                      date1..ToString("yyyy-MM-dd"), date2..ToString("yyyy-MM-dd"));
  ASPxGridView1.FilterExpression = filter;
  

  VB.NET

  Dim date1 As DateTime = New DateTime(1995, 1, 1)
  Dim date2 As DateTime = New DateTime(1995, 7, 1)
  Dim filter As String = String.Format("[OrderDate] > #{0}# And [OrderDate] < #{1}#", date1..ToString("yyyy-MM-dd"), date2..ToString("yyyy-MM-dd"))
  ASPxGridView1.FilterExpression = filter
  

• Applying a filter that selects departments whose budget is greater than 100,000 and that are located in Monterey. The filter criteria are displayed within the ASPxGridView’s Title Panel.

  C#

  ASPxGridView1.FilterExpression = "[Budget] > 100000  AND [Location] = 'Monterey'";
  ASPxGridView1.SettingsText.Title = ASPxGridView1.FilterExpression;
  

  VB.NET

  ASPxGridView1.FilterExpression = "[Budget] > 100000  AND [Location] = 'Monterey'"
  ASPxGridView1.SettingsText.Title = ASPxGridView1.FilterExpression
  

  Result:

  

• Select data rows whose product name starts with “ch”.

  C#

  ASPxGridView1.FilterExpression = "StartsWith([ProductName], 'ch')";
  

  VB.NET

  ASPxGridView1.FilterExpression = "StartsWith([ProductName], 'ch')"
  

• Get field names from the filter expression value.

  C#

  int start = -1;
  List<string> fields = new List<string>();
  for (int i = 0; i < ASPxGridView1.FilterExpression.Length; i++) {
      if (ASPxGridView1.FilterExpression[i] == '[')
          start = i;
      if (ASPxGridView1.FilterExpression[i] == ']') {
          fields.Add(ASPxGridView1.FilterExpression.Substring(start + 1, i - start - 1));
          start = -1;
      }
  }
  

  VB.NET

      Dim start As Integer = -1
      Dim fields As List(Of String) = New List(Of String)()
  
      For i As Integer = 0 To ASPxGridView1.FilterExpression.Length - 1
          If ASPxGridView1.FilterExpression(i) = "["c Then start = i
  
          If ASPxGridView1.FilterExpression(i) = "]"c Then
              fields.Add(ASPxGridView1.FilterExpression.Substring(start + 1, i - start - 1))
              start = -1
          End If
      Next
  

Online Demos

• ASPxGridView - Filter Control
• ASPxCardView - Filter Control
• ASPxVerticalGrid - Filter Control

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the FilterExpression property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

VB.NET

how-to-export-grouped-grid-with-page-breaks-between-groups-e1597/VB/WebApplication211/Default.aspx.vb#L52

End If
Dim filter As String = ASPxGridView1.FilterExpression
ASPxGridView1.FilterExpression = New GroupOperator(GroupOperatorType.And, CriteriaOperator.Parse(filter), New BinaryOperator(groupField, groupValues(i))).ToString()

the-timespan-data-support-in-the-aspxgridview-e1591/VB/TimeSpanColumn/Default.aspx.vb#L22

    Dim filter As CriteriaOperator = New OperandProperty("TimeSpan") = New OperandValue(New TimeSpan(1, 0, 0))
    ASPxGridView1.FilterExpression = filter.ToString()
End If

how-to-convert-and-then-print-an-gridview-extension-by-using-the-xtrareport-e4755/VB/E4755/Models/MVCxGridViewState.vb#L74

    Next item
    FilterExpression = gridView.FilterExpression
End Sub

C#

the-timespan-data-support-in-the-aspxgridview-e1591/CS/TimeSpanColumn/Default.aspx.cs#L20

    CriteriaOperator filter = new OperandProperty("TimeSpan") == new OperandValue(new TimeSpan(1, 0, 0));
    ASPxGridView1.FilterExpression = filter.ToString();
}

how-to-convert-and-then-print-an-gridview-extension-by-using-the-xtrareport-e4755/CS/E4755/Models/MVCxGridViewState.cs#L17

    }
    FilterExpression = gridView.FilterExpression;
}