CriteriaOperator.ToString() Method

Converts the current expression into its VB equivalent string.

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v23.2.dll

NuGet Package: DevExpress.Data

Declaration

C#

public override string ToString()

VB.NET

Public Overrides Function ToString As String

Returns

Type	Description
String	A string representation of this expression.

Remarks

To convert the string representation of an expression into its CriteriaOperator equivalent, use the CriteriaOperator.Parse method.

Note

The ToString method returns a string representation of the criteria which can be displayed in UI or saved in application log. However, this string is actually not SQL and cannot be considered as such.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ToString() 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#

XPO_how-to-filter-a-collection-by-an-associated-objects-properties-e886/CS/Form1.cs#L307

else
    labelControl1.Text = criteria.ToString();
labelControl2.Text = string.Format("Total row count: {0}", xpCollection1.Count);

asp-net-mvc-grid-master-detail-and-custom-binding/CS/Example/Controllers/HomeController.cs#L80

viewModel.Columns.Add("UnitPrice");
viewModel.FilterExpression = (new BinaryOperator("CustomerID", customerID)).ToString();
return viewModel;

winforms-dashboard-filtering-in-olap-mode/CS/Dashboard_OlapFiltering/Form1.cs#L38

pivot1.FilterString = filterCriteria.ToString();
dashboardDesigner1.Dashboard = dashboard;

wpf-data-grid-filter-columns-bound-to-collection-properties/CS/FilterDropDown_AgregateOperators/Behaviors/InToAggregatePatcher.cs#L21

var inOperator = new InOperator(new OperandProperty(DataItemId), ItemValues);
var newOperator = CriteriaOperator.Parse(FieldName + "[" + inOperator.ToString() + "]");
return newOperator;

VB.NET

XDL_how-to-delete-all-criteria-corresponding-to-a-particular-field-from-criteriaoperator-e3396/VB/PatchCriteriaExample/Program.vb#L16

Dim expectedResult As String = "[A] = 'B'"
Dim aggregateSkipCollection As String = CriteriaPatcherSkipProperties.Patch(CriteriaOperator.Parse("ToRemove[C = 'D'] and A = 'B'"), "ToRemove").ToString()
Dim aggregateSkipCondition As String = CriteriaPatcherSkipProperties.Patch(CriteriaOperator.Parse("C[ToRemove = 'D'] and A = 'B'"), "ToRemove").ToString()

XPO_how-to-filter-a-collection-by-an-associated-objects-properties-e886/VB/Form1.vb#L297

Else
    labelControl1.Text = criteria.ToString()
End If

asp-net-mvc-grid-master-detail-and-custom-binding/VB/Example/Controllers/HomeController.vb#L74

viewModel.Columns.Add("UnitPrice")
viewModel.FilterExpression = (New BinaryOperator("CustomerID", customerID)).ToString()
Return viewModel

winforms-dashboard-filtering-in-olap-mode/VB/Dashboard_OlapFiltering/Form1.vb#L35

pivot1.FilterString = filterCriteria.ToString()
dashboardDesigner1.Dashboard = dashboard

wpf-data-grid-filter-columns-bound-to-collection-properties/VB/FilterDropDown_AgregateOperators/Behaviors/InToAggregatePatcher.vb#L25

Dim inOperator = New InOperator(New OperandProperty(DataItemId), ItemValues)
Dim newOperator = CriteriaOperator.Parse(FieldName & "[" & inOperator.ToString() & "]")
Return newOperator