CriteriaOperator.Parse(String, Object[]) Method

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

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v23.2.dll

NuGet Package: DevExpress.Data

Declaration

C#

public static CriteriaOperator Parse(
    string criteria,
    params object[] parameters
)

VB.NET

Public Shared Function Parse(
    criteria As String,
    ParamArray parameters As Object()
) As CriteriaOperator

Parameters

Name	Type	Description
criteria	String	A String value, that is the expression to convert.
parameters	Object[]	The values that are substituted into the expression in place of question mark characters. These parameters can be omitted.

Returns

Type	Description
CriteriaOperator	A CriteriaOperator equivalent to the expression contained in criteria.

Remarks

This example retrieves the cars that belong to the Saloon category and cost less than $100,000.

C#

xpCollection1.Filter = CriteriaOperator.Parse("[Category] = ? AND [Price] < ?", "Saloon", 100000);

VB.NET

XPCollection1.Filter = CriteriaOperator.Parse("[Category] = ? AND [Price] < ?", "Saloon", 100000)

The image below shows the result:

To learn more, see Limitations of CriteriaOperator.Parse and Criteria Language Syntax.

Note

The code example above uses positional parameters to format a criteria expression with values. For more information on positional parameters, refer to the corresponding section in the Criteria Language Syntax topic.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Parse(String, Object[]) method.

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#

CriteriaOperatorsCheatSheet/CS/CriteriaOperatorCheatSheet/Tests/Aggregate_Count.cs#L19

CriteriaOperator criterion =
    CriteriaOperator.Parse("Count()");
var result = uow.Evaluate<Order>(criterion, null);

asp-net-mvc-grid-custom-binding-and-xpo/CS/XPCustomBindingExample/XPO/StartupHelper.cs#L22

int ordersCnt = (int)uow.Evaluate(classInfo, CriteriaOperator.Parse("count"), null);
if(ordersCnt > 0) return;

xaf-how-to-show-a-custom-form-as-the-winforms-dashboard-designer/CS/CustomDashboardDesignerForm.Module/DatabaseUpdate/Updater.cs#L18

base.UpdateDatabaseAfterUpdateSchema();
Contact contactMary = ObjectSpace.FindObject<Contact>(CriteriaOperator.Parse("FirstName == 'Mary' && LastName == 'Tellitson'"));
if (contactMary == null)

xaf-win-web-open-detail-view-when-grid-row-is-clicked-in-the-dashboard/CS/ShowDetailViewFromDashboard.Module/DatabaseUpdate/Updater.cs#L17

base.UpdateDatabaseAfterUpdateSchema();
Contact contactMary = ObjectSpace.FindObject<Contact>(CriteriaOperator.Parse("FirstName == 'Mary' && LastName == 'Tellitson'"));
if(contactMary == null) {

XPO_how-to-implement-custom-aggregates/CS/XpoCustomAggregate/Form1.cs#L20

XPView xpView = new XPView(session1, typeof(Customer));
xpView.AddProperty("ContactName", CriteriaOperator.Parse("[FirstName] + ' ' + [LastName]"));
xpView.AddProperty("DistinctProducts", CriteriaOperator.Parse("[Orders][].CountDistinct([ProductName])"));

VB.NET

asp-net-mvc-grid-custom-binding-and-xpo/VB/XPCustomBindingExample/XPO/XpoBindingHandlers.vb#L24

Public Sub GetDataRowCount(ByVal e As GridViewCustomBindingGetDataRowCountArgs)
    Dim filter As CriteriaOperator = CriteriaOperator.Parse(e.FilterExpression)
    Dim expression As CriteriaOperator = CriteriaOperator.Parse("count")

xaf-how-to-show-a-custom-form-as-the-winforms-dashboard-designer/VB/CustomDashboardDesignerForm.Module/DatabaseUpdate/Updater.vb#L19

MyBase.UpdateDatabaseAfterUpdateSchema()
Dim contactMary As Contact = ObjectSpace.FindObject(Of Contact)(CriteriaOperator.Parse("FirstName == 'Mary' && LastName == 'Tellitson'"))
If contactMary Is Nothing Then

xaf-win-web-open-detail-view-when-grid-row-is-clicked-in-the-dashboard/VB/ShowDetailViewFromDashboard.Module/DatabaseUpdate/Updater.vb#L19

MyBase.UpdateDatabaseAfterUpdateSchema()
Dim contactMary As Contact = ObjectSpace.FindObject(Of Contact)(CriteriaOperator.Parse("FirstName == 'Mary' && LastName == 'Tellitson'"))
If contactMary Is Nothing Then

XPO_how-to-implement-custom-aggregates/VB/XpoCustomAggregate/Form1.vb#L21

Dim xpView As New XPView(session1, GetType(Customer))
xpView.AddProperty("ContactName", CriteriaOperator.Parse("[FirstName] + ' ' + [LastName]"))
xpView.AddProperty("DistinctProducts", CriteriaOperator.Parse("[Orders][].CountDistinct([ProductName])"))

XPO_how-to-use-string-functions-in-criteria-e264/VB/UpperFunctionTest.vb#L29

' Test UPPER
Dim filter As CriteriaOperator = CriteriaOperator.Parse("Upper([MyCaseSensitiveProperty]) = ?", "AB")
Dim collection As XPCollection(Of MyObject) = New XPCollection(Of MyObject)(uof, filter)