0

I'm getting below error when I added 'offset' property in JSON query of CubeJS.

It gives me a proper response when I added only 'limit' property in JSON query. but gives an error when I added 'limit' with 'offset' property.

http://localhost:3000/cubejs-api/v1/load?query={
  "dimensions": [
    "Order.driver",
    "Order.ivhTractor",
    "Order.shipper",
    "Order.consignee",
    "Order.division",
    "Order.ordNumber"
  ],
  "timeDimensions": [],
  "filters": [
    {
      "dimension": "Order.ivhTractor",
      "operator": "equals",
      "values": [
        "321"
      ]
    }
  ],
  "limit": 50,
  "offset": 10
}

I expect success response which skips 10 records, but getting below error:

{
    "error": "Invalid query format: \"offset\" is not allowed"
}
Yaser Darzi
  • 1,480
  • 12
  • 24
Harshal Nathe
  • 95
  • 1
  • 8
  • Could you please share which version of Cube.js you use? – Pavel Tiunov Sep 26 '19 at 00:53
  • @Pavel I am using npm module **"@cubejs-backend/server-core": "^0.10.16"** for cubeJS backend and as I am using MySQL database hence, also added another npm model which is **"@cubejs-backend/mysql-driver": "^0.10.16"** – Harshal Nathe Sep 27 '19 at 06:06

1 Answers1

0

Most likely it's due to old version is used. offset param was introduced in 0.10.21: https://github.com/cube-js/cube.js/blob/master/CHANGELOG.md#01021-2019-08-05

Pavel Tiunov
  • 1,163
  • 6
  • 8