Last Updated: 29 Jun 2018 13:01 by ADMIN
Created on: 19 Mar 2018 13:07
Category: GridView
Type: Bug Report
FIX. RadGridView - the Does Not Contain filter eliminates null values after version 2015.3.930
Use attached to reproduce.

With versions prior 2015.3.930 the results are different.
1 comment
Posted on: 29 Jun 2018 13:00
The current behavior is correct.

Setting a FilterDescriptor with a DoesNotContain operator results in creating a NOT LIKE expression, e.g. like this one: "[Region] NOT LIKE '%SP%'". With such an expression any NULL values should be filtered.  This scenario can be tested directly in SQL server by running the following query against the Customers table of the Northwind database: 

SELECT * FROM [NORTHWND].[dbo].[Customers]
Where ([Region] NOT LIKE '%SP%')

With the expression above all records with Region equalling NULL are filtered. A similar question is also discussed here:

"Comparisons with NULL not using IS NULL or IS NOT NULL return NULL instead of true or false in most/all database systems."