[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Expand]Controls and Libraries
 [Collapse]Common Features
  [Expand]Data Binding Common Concepts
  [Expand]Data Source Wizard
  [Collapse]Expressions
    Expression Editor
    Custom Functions
    Custom Function Based Filters
    Member Table: Expressions
  [Expand]Behaviors
  [Expand]Application Appearance and Skin Colors
  [Expand]Filtering UI Context
   Find Panel Syntax
  [Expand]Graphics Performance and High DPI
  [Expand]Scaffolding Wizard
  [Expand]Formatting Values
   HTML-inspired Text Formatting
  [Expand]Menus
  [Expand]Tooltip Management
  [Expand]Save and Restore Layouts
   Clipboard - Copy and Paste Operations. Data Formatting
   Version Compatibility: Default Property Values
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Custom Functions

Expanded Overview

Expressions support multiple predefined functions.

  • Aggregate Functions (for example, average value).
  • Date-time Functions (for example, is today).
  • Logical Functions (for example, is null or empty).
  • Math Functions (for example, absolute value).
  • String Functions (for example, starts with).

These functions allow you to calculate values for unbound columns, implement conditional formatting or create complex filters. For example, you can only show orders that exceed the average cost and are shipped today. See Criteria Language Syntax for more information.

You can also create a custom function. For example, you can implement not starts with function.

Expanded How to Implement a Custom Function

To create a custom function, implement one of these interfaces.

Note

The How to: Implement a Custom Criteria Language Function Operator topic shows how to implement a function that extracts the month from a date-time value.

Expanded How to Register a Custom Function

A custom function should be registered in the system to make it available in expressions and/or database queries. To register a function, do one of the following:

To unregister a custom function, call the CriteriaOperator.UnregisterCustomFunction method.

Note

Refer to How to: Implement Custom Functions and Criteria in LINQ to XPO for more information on how to implement custom functions and use them in LINQ expressions created with XPO.

Expanded See Also

Is this topic helpful?​​​​​​​