I have a nullable Guid column in my grid that is using an editor template to display a the text value associated with the Guid in the lookup table.
columns.ForeignKey(p => p.NotAcceptableReason, (System.Collections.IEnumerable)ViewBag.NotAcceptableReasons,
"NotAcceptableReasonId"
,
"NotAcceptableReasonName"
).Width(200);
The editor template:
@
using
Kendo.Mvc.UI
@model
object
@(
Html.Kendo().DropDownListFor(m => m)
.BindTo((SelectList)ViewData[ViewData.TemplateInfo.GetFullHtmlFieldName(
""
) +
"_Data"
])
.OptionLabel(
"--- Select ---"
)
.ValuePrimitive(
true
)
)
On that column's column filter popup,I get all the text values from the lookup table in a drop down list and the filtering work as expected.
However, when I try to filter the column on "Is null" or "Is not null" I get an error -> System.FormatException: Unrecognized Guid format.
I suspect this is because there is no NULL entry in the lookup table I'm binding the drop down list to. Any suggestions for getting the "Is null" or "Is not null" column filters to work correctly in this scenario?