02-07-2017 12:55 PM
When you define OData-Service with DateTime keys, for any reason OData Explorer is using datetimeoffset instead of datetime, which is not working:
Here is the issue:
1.) not working:
https://.../viztool3/service/viztool3.xsodata/Routes(routeNumber=1000,stredaDate=datetimeoffset'2016-8-8T0:00:00.0')/Attributes?&$top=500
2.) working:
https://.../viztool3/service/viztool3.xsodata/Routes(routeNumber=1001,stredaDate=datetime'2016-08-08')/Attributes(routeNumber=1001,attribute=5,stredaDate=datetime'2016-08-08T00:00:00.0000000')
With 1.) you get "Bad request" / "Illegal query syntax"
Is there a fix for that ?