Fiware Quantum Leap Date Query

196 Views Asked by At

I am currently using Quantum Leap/CrateDB to persist time series data through the Orion Context Broker.

After setting up the notification on Orion I can query data.

curl -X GET "http://localhost:8668/v2/entities/urn:ngsi-ld:Pmr_obs:001/attrs/slotStatus?limit=3" -H "Accept: application/json" -H "Fiware-Service: atos" -H "Fiware-ServicePath: /mtp"

Response

{
  "attrName": "slotStatus",
  "entityId": "urn:ngsi-ld:Pmr_obs:001",
  "index": [
    "2019-07-28T19:00:00.000+00:00",
    "2019-07-29T07:00:00.000+00:00",
    "2019-07-29T10:00:00.000+00:00"
  ],
  "values": [
    0,
    1,
    0
  ]
}

But when I try to query data over a specific period (between two dates), the server returns all the indices and the values and not for the period I select.

curl -X GET "http://localhost:8668/v2/entities/urn:ngsi-ld:Pmr_obs:001/attrs/slotStatus?dateFrom=2020-12-01T00:00:00.000Z&dateTo=2020-12-31T23:59:59.999Z" -H "Accept: application/json" -H "Fiware-Service: atos" -H "Fiware-ServicePath: /mtp"
Response (all the values from 2019 to end of 2020)

What is strange is that if I use an aggregate method it filters the data correctly using the specific date period.

curl -X GET "http://localhost:8668/v2/entities/urn:ngsi-ld:Pmr_obs:001/attrs/slotStatus?aggrMethod=count&dateFrom=2020-12-01&dateTo=2020-12-31" -H "Accept: application/json" -H "Fiware-Service: atos" -H "Fiware-ServicePath: /mtp"

Response

{
  "attrName": "slotStatus",
  "entityId": "urn:ngsi-ld:Pmr_obs:001",
  "index": [],
  "values": [
    1101
  ]
}

What should I do to only query data from a specific period without an aggregate method?

Thanks in advance.

quantumleap:0.8 crate:4.1.4

1

There are 1 best solutions below

0
Federico Michele Facca On BEST ANSWER

We investigated the issue.

the query used contains dateFrom and dateTo but as per quantumleap's API specification it should be fromDate and toDate (which should work fine).