2

Closed

QueryableAttribute doesn't support operators on DateTimeOffset property

description

http://localhost:9022/api/FilterTests/GetProducts?$filter=DateTimeOffset eq datetimeoffset'2011-06-01T14:03:00' Respose Content: {"Message":"The query specified in the URI is not valid.","ExceptionMessage":"A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.DateTimeOffset' for operator kind 'Equal'.","ExceptionType":"Microsoft.Data.OData.ODataException","StackTrace":" at Microsoft.Data.OData.Query.MetadataBinder.BindBinaryOperator(BinaryOperatorQueryToken binaryOperatorToken)\r\n at Microsoft.Data.OData.Query.MetadataBinder.Bind(QueryToken token)\r\n at Microsoft.Data.OData.Query.MetadataBinder.ProcessFilter(QueryNode query, QueryToken filter)\r\n at Microsoft.Data.OData.Query.MetadataBinder.BindTree(SyntacticTree syntax)\r\n at Microsoft.Data.OData.Query.MetadataBinder.BindQuery(SyntacticTree syntax)\r\n at Microsoft.Data.OData.Query.SemanticTree.ParseUri(Uri queryUri, Uri serviceBaseUri, IEdmModel model, Int32 maxDepth)\r\n at Microsoft.Data.OData.Query.SemanticTree.ParseUri(Uri queryUri, Uri serviceBaseUri, IEdmModel model)\r\n at System.Web.Http.OData.Query.FilterQueryOption.get_QueryNode() in C:\dd\DevDiv\Offcycle\WPT\WebStackRuntime\runtime\src\System.Web.Http.OData\OData\Query\FilterQueryOption.cs:line 68\r\n at System.Web.Http.OData.Query.FilterQueryOption.ApplyTo(IQueryable query, Boolean handleNullPropagation, IAssembliesResolver assembliesResolver) in C:\dd\DevDiv\Offcycle\WPT\WebStackRuntime\runtime\src\System.Web.Http.OData\OData\Query\FilterQueryOption.cs:line 100\r\n at System.Web.Http.OData.Query.ODataQueryOptions.ApplyTo(IQueryable query, Boolean handleNullPropagation, Boolean canUseDefaultOrderBy) in C:\dd\DevDiv\Offcycle\WPT\WebStackRuntime\runtime\src\System.Web.Http.OData\OData\Query\ODataQueryOptions.cs:line 213\r\n at System.Web.Http.OData.Query.ODataQueryOptions.ApplyTo(IQueryable query, Boolean handleNullPropagation) in C:\dd\DevDiv\Offcycle\WPT\WebStackRuntime\runtime\src\System.Web.Http.OData\OData\Query\ODataQueryOptions.cs:line 191\r\n at System.Web.Http.OData.Query.ODataQueryOptions.ApplyTo(IQueryable query) in C:\dd\DevDiv\Offcycle\WPT\WebStackRuntime\runtime\src\System.Web.Http.OData\OData\Query\ODataQueryOptions.cs:line 180\r\n at System.Web.Http.QueryableAttribute.OnActionExecuted(HttpActionExecutedContext actionExecutedContext) in C:\dd\DevDiv\Offcycle\WPT\WebStackRuntime\runtime\src\System.Web.Http.OData\QueryableAttribute.cs:line 168"}
Closed Jan 3 at 8:42 PM by hongyes
Verified

comments

HongmeiG wrote Oct 4, 2012 at 11:52 PM

This is an external issue with OData Uri Parser.

HongmeiG wrote Dec 14, 2012 at 9:35 PM

The latest ODataLib has the fix.