cube-js / cube-js/cube

Adding offset attribute to the query leads to fatal error

Open
#6,880 2 comments 0 reactions 0 assignees View on GitHub
driver:elasticsearch help wanted
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

**Describe the bug**
In order to enable pagination we are trying to use offset and limit, but as soon as I am adding the "offset" attribute to the query dictionary the cubejs is responding with an error message. This is a BLOCKER issue for our production release.

**To Reproduce**
Steps to reproduce the behavior:
1. Run CubeJS rest api with the following payload:
`{"measures":["items.count"],"timeDimensions":[{"dimension":"items.created_on","granularity":"year"}],"dimensions":["items.id","items.created_on"],"limit":3,"offset":1,"order":[["items.modified_on","asc"]]}`

**Expected behavior**
It should respond with proper results with the offsets attribute in action.

**Minimally reproducible Cube Schema**
Cube data backend: ELASTIC SEARCH

```javascript
cube(`items`, {
sql_table: `items`,

data_source: `default`,

joins: {

},

dimensions: {
id: {
sql: `id`,
type: `string`,
primary_key: true
},
email: {
sql: `email`,
type: `string`
},

name: {
sql: `name`,
type: `string`
},

created_on: {
sql: `created_on`,
type: `time`
},

modified_on: {
sql: `modified_on`,
type: `time`
}
},

measures: {
count: {
type: `count`
}
},

pre_aggregations: {
// Pre-aggregation definitions go here.
// Learn more in the documentation: https://cube.dev/docs/caching/pre-aggregations/getting-started
}
});
```

**Version:**
0.33.35

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.