Skip to Content
0

SAP HANA OData Explorer Issue with OData Date key

Feb 07, 2017 at 12:55 PM

35

avatar image
Former Member

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 ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers