DataGrid Bool and Bool? filters not handled correctly in QueryableExtension.cs GetColumnFilter #1356

Closed
opened 2026-01-29 17:52:31 +00:00 by claunia · 0 comments
Owner

Originally created by @ONYXDave on GitHub (Aug 20, 2024).

Setting Filter to Is Null results in filter string "column ==" it should be "column== null"
Setting filter to Not Equal set filter string "column == true" should be "column!= true"

Proposed code changes.

else if (column.FilterPropertyType == typeof(bool) || column.FilterPropertyType == typeof(bool?))
{
//Added for is Null Is Not Null
if (columnFilterOperator == FilterOperator.IsNull || columnFilterOperator == FilterOperator.IsNotNull)
{
return $"{property} {linqOperator} null";
}
//
return $"{property} {linqOperator} {value}"; //Changed == to {linqOperator} fixes not equal to
}

Originally created by @ONYXDave on GitHub (Aug 20, 2024). Setting Filter to Is Null results in filter string "column ==" it should be "column== null" Setting filter to Not Equal set filter string "column == true" should be "column!= true" Proposed code changes. else if (column.FilterPropertyType == typeof(bool) || column.FilterPropertyType == typeof(bool?)) { //Added for is Null Is Not Null if (columnFilterOperator == FilterOperator.IsNull || columnFilterOperator == FilterOperator.IsNotNull) { return $"{property} {linqOperator} null"; } // return $"{property} {linqOperator} {value}"; //Changed == to {linqOperator} fixes not equal to }
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/radzen-blazor#1356