The query specified in the URI is not valid. The binary operator GreaterThanOrEqual is not defined for the types 'System.Nullable1[System.DateOnly]' and 'System.Nullable
1[System.DateTimeOffset]'.
#989
Labels
Assemblies affected
ASP.NET , OData 8.2.0
Describe the bug
The query specified in the URI is not valid. The binary operator GreaterThanOrEqual is not defined for the types 'System.Nullable
1[System.DateOnly]' and 'System.Nullable
1[System.DateTimeOffset]'.Reproduce steps
http://localhost:5000/odata/Student?$filter=(CREATION_DATE ge 2020-01-01)
Data Model
Please share your Data model, for example, your C# class.
EDM (CSDL) Model
{
"$Version": "4.0",
"$EntityContainer": "Default.Container",
"Dynamic.Objects.d81b92f4-c077-44d2-98e1-85858764a468.Relations": {
"Student": {
"$Kind": "EntityType",
"$Key": [
"Id"
],
"Id": {
"$Type": "Edm.Guid"
},
"CHANGE_DATE": {
"$Type": "Edm.Date"
},
"CHANGED_BY": {
"$Type": "Edm.TimeOfDay",
"$Precision": 0
},
"CREATED_BY": {
"$Type": "Edm.TimeOfDay",
"$Precision": 0
},
"CREATION_DATE": {
"$Type": "Edm.Date"
}
}
},
}
Request/Response
http://localhost:5000/odata/Student?$filter=(CREATION_DATE ge 2020-01-01)
Please share your response head, body.
Expected behavior
get result according to filter fine.
Screenshots
If applicable, add screenshots to help explain your problem.
Additional context
Please share your call stack or any error message
Add any other context about the problem here.
The text was updated successfully, but these errors were encountered: