Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA OData Explorer Issue with OData Date key

jarljansen
Explorer
0 Kudos

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 ?

  • SAP Managed Tags:
0 REPLIES 0