Unable to query nullable fields via LINQ expressions

[SPWizard01]

Category

• Bug

Describe the bug

i.e. you want to query Site Pages for anything that has been published straight away or scheduled time is less than now will throw an error:

System.NotSupportedException: Node of type Equal of expression ((c.Values.get_Item("OData__PublishStartDate") As Nullable`1) == null) is not supported

Steps to reproduce

this works:

            var items = await myList.Items.Where(c =>
                (c.Values["OData__PublishStartDate"] as DateTimeOffset?) <= now
            ).ToListAsync();

this does not:

            var items = await myList.Items.Where(c =>
                (c.Values["OData__PublishStartDate"] as DateTimeOffset?) <= now ||
                (c.Values["OData__PublishStartDate"] as DateTimeOffset?) == null
            ).ToListAsync();

Expected behavior

the OData Query that is produced should be

OData__PublishStartDate le datetime'2024-09-15T05:18:54Z' or OData__PublishStartDate eq null

Environment details (development & target environment)

• SDK version: 1.14
• OS: Win 11
• SDK used in: ASP.Net Web app
• Framework: .NET Core v8
• Browser(s): Chromium Edge Latest
• Tooling: Visual Studio 2022

Additional context

In my opinion the problem is here:

pnpcore/src/sdk/PnP.Core/QueryModel/Query/DataModelQueryTranslator.cs

Line 216 in 3592355

if (filterField != null && filterValue != null)

I am not sure if null check should be performed on the value.