PivotGridFieldBase.PrefilterColumnName Property

Gets the name by which the field is referred to in the Prefilter expression.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v20.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.WindowsDesktop.PivotGrid.Core

Declaration

C#

[Browsable(false)]
public string PrefilterColumnName { get; }

VB.NET

<Browsable(False)>
Public ReadOnly Property PrefilterColumnName As String

Property Value

Type	Description
String	A String, specifying the name by which the field is referred to in the Prefilter expression.

Remarks

When you create a Prefilter expression in code, use the PrefilterColumnName property to refer to a field. The sample below shows how to do it:

C#

pivotgridControl1.Prefilter.CriteriaString = "[" + fieldCategory.PrefilterColumnName + "] Like 'B%'";

VB.NET

pivotgridControl1.Prefilter.CriteriaString = "[" + fieldCategory.PrefilterColumnName + "] Like 'B%'"

To specify a Prefilter expression, use the BaseFilter.Criteria or BaseFilter.CriteriaString property.

To learn more, see Prefilter and Pivot Grid Expression Syntax.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the PrefilterColumnName 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.

C#

how-to-change-the-prefilters-filter-criteria-in-code-e1869/CS/ASPxPivotGrid_ChangingPrefilterCriteria/Default.aspx.cs#L7

protected void Page_Load(object sender, EventArgs e) {
    ASPxPivotGrid1.Prefilter.CriteriaString = "[" + fieldCountry.PrefilterColumnName +
        "] == 'UK' OR [" + fieldCountry.PrefilterColumnName + "] == 'USA'";

VB.NET

how-to-change-the-prefilters-filter-criteria-in-code-e1869/VB/ASPxPivotGrid_ChangingPrefilterCriteria/Default.aspx.vb#L9

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
    ASPxPivotGrid1.Prefilter.CriteriaString = "[" & fieldCountry.PrefilterColumnName & "] == 'UK' OR [" & fieldCountry.PrefilterColumnName & "] == 'USA'"
End Sub