on 02-02-2016 2:03 PM
I am using the builtin OData API from the IoT MMS services and datetime filtering is not working.
I tried this request :
https://<host>/com.sap.iotservices.mms/v1/api/http/app.svc/MY_TABLE?$filter=MY_COLUMN gt datetime'2016-01-01T00:00:00'
and I get the following error: Requested entity could not be found
<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<code></code>
<message xml:lang="en-US">Requested entity could not be found.</message>
</error>
I know that the column and table exist, and that the column is of type datetime.I can also filter by any other column (of other types, like string) and it works, so the filter syntax should be good.
Is the filtering of datetime not supported by the builtin OData API ?
Hi Rares,
a filter syntax is actually correct. I am going to check what the problem is on the MMS side and will keep you updated.
Sorry for the inconvenience,
Anton
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is the MMS release rolled out ?
I have the same problem with filtering, as described here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
http://help.sap.com/saphelp_hanaplatform/helpdata/en/25/6287e2132b478b9066017a4a4998e4/content.htm
Thank you for a quick answer !
It's working now.
I tried the Filter Option for "Starts with", and that's not working.
I found the url where supported options are defined, and "starts with" is not part of that.
Supported options are working perfect. 🙂
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.