Skip to Content
avatar image
Former Member

SAP HANA OData Explorer Issue with OData Date key

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers