WebPrefilter.Criteria Property

Gets or sets the Prefilter's expression.

Namespace: DevExpress.Web.ASPxPivotGrid.Data

Assembly: DevExpress.Web.ASPxPivotGrid.v20.2.dll

Declaration

[DefaultValue(null)]
public CriteriaOperator Criteria { get; set; }
<DefaultValue(Nothing)>
Public Property Criteria As CriteriaOperator

Property Value

Type Default Description
CriteriaOperator

null

A CriteriaOperator descendant that represents the Prefilter's expression.

Available values:

Show 47 items
Name Description
QueryCustomFunctions
CustomAggregateCount
CustomFunctionCount

Returns the number of custom functions registered in an application via the CriteriaOperator.RegisterCustomFunction and CriteriaOperator.RegisterCustomFunctions method calls.

CriterionEquals(CriteriaOperator, CriteriaOperator)

This method is intended for internal use.

GetCustomAggregates()

Searches custom aggregate functions registered in an application via the RegisterCustomAggregate(ICustomAggregate) and RegisterCustomAggregates(IEnumerable<ICustomAggregate>) method calls.

GetCustomAggregate(String)

Searches custom aggregate functions registered in an application via the RegisterCustomAggregate(ICustomAggregate) and RegisterCustomAggregates(IEnumerable<ICustomAggregate>) method calls for a function with a specified name.

UnregisterCustomAggregate(ICustomAggregate)

Unregisters a specified custom aggregate function from use in any CriteriaOperator-based criteria in your application.

UnregisterCustomAggregate(String)

Unregisters a custom aggregate function with a specified name from use in any CriteriaOperator-based criteria in your application.

RegisterCustomAggregates(IEnumerable<ICustomAggregate>)

Registers custom aggregate functions to use in any CriteriaOperator-based criteria in your application.

RegisterCustomAggregate(ICustomAggregate)

Registers a custom aggregate function to use in any CriteriaOperator-based criteria in your application.

GetCustomFunction(String)

Searches custom functions registered in an application via the CriteriaOperator.RegisterCustomFunction and CriteriaOperator.RegisterCustomFunctions method calls for a function with a specified name.

UnregisterCustomFunction(ICustomFunctionOperator)

Unregisters a specified custom function from use in any CriteriaOperator-based criteria in your application.

UnregisterCustomFunction(String)

Unregisters a custom function with a specified name from use in any CriteriaOperator-based criteria in your application.

RegisterCustomFunctions(IEnumerable<ICustomFunctionOperator>)

Registers specified custom functions to use in any CriteriaOperator-based criteria in your application.

RegisterCustomFunction(ICustomFunctionOperator)

Registers a specified custom function to use in any CriteriaOperator-based criteria in your application.

Clone(OperandProperty)

Creates a copy of the specified OperandProperty object.

Clone(CriteriaOperator)

Creates a copy of the specified CriteriaOperator object.

Not()

Returns an instance of the UnaryOperator that represents the criterion resulting from the logical inversion of the criterion the current CriteriaOperator represents.

IsNotNull()

For internal use only.

IsNull()

For internal use only.

Or(IEnumerable<CriteriaOperator>)

Returns the expression which groups the specified operands with logical OR.

Or(CriteriaOperator[])

Returns the expression which groups the specified operands with logical OR.

Or(CriteriaOperator, CriteriaOperator)

Returns the expression which groups two operands with logical OR.

And(IEnumerable<CriteriaOperator>)

Returns the expression which groups the specified operands with logical AND.

And(CriteriaOperator[])

Returns the expression which groups the specified operands with logical AND.

And(CriteriaOperator, CriteriaOperator)

Returns the expression which groups two operands with logical AND.

ToString()

Converts the current expression into its VB equivalent string.

ToString(CriteriaOperator, out OperandValue[])

Converts the specified expression into its equivalent string in VB style.

ToString(CriteriaOperator)

Converts the specified expression into its equivalent string in VB style.

LegacyToString()

Returns the string representation of the criteria specified by the current CriteriaOperator instance.

LegacyToString(CriteriaOperator)

Returns the string representation of a specified criteria.

ToCStyleString(CriteriaOperator, out OperandValue[])

Converts the specified expression into its equivalent string in C# style.

ToCStyleString(CriteriaOperator)

Converts the specified expression into its equivalent string in C# style.

ToBasicStyleString(CriteriaOperator, out OperandValue[])

Converts the specified expression into its equivalent string in VB style.

ToBasicStyleString(CriteriaOperator)

Converts the specified expression into its equivalent string in VB style.

ParseList(String, Object[])

Converts the specified string representation of expressions that are divided by a semicolon into their CriteriaOperator equivalents.

ParseList(String, out OperandValue[])

Converts the specified string representation of expressions that are divided by a semicolon into their CriteriaOperator equivalents.

TryParse(String, Object[])

Tries to convert the specified string representation of an expression to its CriteriaOperator equivalent.

Parse(String, Object[])

Converts the specified string, specifying an expression, to its CriteriaOperator equivalent.

Parse(String, out OperandValue[])

Converts the specified string, specifying an expression, to its CriteriaOperator equivalent.

Accept<T>(ICriteriaVisitor<T>)

This member supports the internal infrastructure, and is not intended to be used directly from your code.

Accept(ICriteriaVisitor)

This member supports the internal infrastructure, and is not intended to be used directly from your code.

GetHashCode()

Gets the hash code (a number) that corresponds to the value of the current CriteriaOperator object.

Equals(Object)

Determines whether the current object has the same settings as the specified object.

UserValueParse

Occurs when restoring a serialized criteria operator that references a user object.

UserValueToString

Occurs when serializing a criteria operator that references a user object.

GetCustomFunctions()

Returns custom functions registered in an application via the CriteriaOperator.RegisterCustomFunction and CriteriaOperator.RegisterCustomFunctions method calls.

Remarks

Use the Criteria property to obtain the Prefilter's current expression. You can also use this property to specify the filter expression in code.

protected void Page_Load(object sender, EventArgs e) {
    if(!IsPostBack && !IsCallback)
        ASPxPivotGrid1.Prefilter.Criteria =
              CriteriaOperator.Parse("fieldOrderYear = 1995 AND fieldOrderQuarter between (2, 4)");
}
NOTE

The Prefilter is not supported in OLAP mode.

See Also