BuyLog In
Breaking Change T1025611
Visible to All Users

Filter builder in Grid and standalone Filter Control now uses IsNullOrEmpty functional operator for Is Blank operator for string properties instead of the IsNull unary operator

What Changed

In v21.1.6 and later, DevExpress ASP.NET Grid View generates the IsNullOrEmpty([Field_Name]) and Not IsNullOrEmpty([Field_Name]) filter criteria for the following filter items:

  • 'Blanks' and 'Non blanks' - in the header filter.

    Clipboard-File-5.png

  • 'Is blank' and 'Is not blank' - in the filter builder.

    Clipboard-File-6.png

Reasons for Change

In previous versions, the control generated different filter criteria for the filter items mentioned above:

  • Header filter.

    'Blanks' - IsNullOrEmpty([Field_Name])
    'Non blanks' - Not IsNullOrEmpty([Field_Name])

  • Filter builder.

    'Is blank' - [Field_Name] Is Null
    'Is not blank' - [Field_Name] Is Not Null

As a result, the grid differently filtered its items by these filter conditions.

Impact on Existing Apps

This change will not affect your application. This change will be applied only to the newly created filter criteria. If you wish old and new criteria to have the same behavior we recommend that you update them or recreate them from scratch.

Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.