cube-js / cube-js/cube

Default date ordering changed with v1.3.24

Open
#9,856 3 comments 0 reactions 1 assignee Claimed by @igorlukanin View on GitHub
api:graphql question
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

**Describe the bug**

Version 1.3.24 changed the default ordering behavior on date queries that have multiple granularities. Previously, querying, say, day and value would order by the value timestamp. With this change, it orders by the day.

https://github.com/cube-js/cube/compare/v1.3.23...v1.3.24

**To Reproduce**

Create a cube that has a date field. Query it with GraphQL like so:

```
query Foo {
cube {
intradayPerformance {
observation_date {
value
day
}
}
}
}
```

With v1.3.23, the results will be ordered ascending by value. With v1.3.24, the results will be ordered by the day. (If you look at the generated SQL, you can see both columns in the select but the order by index changes from the timestamp to the day.)

**Expected behavior**

I expect the v1.3.23 behavior where the order is on the finest date granularity.

**Screenshots**

v1.3.23

Image

v1.3.24

Image

**Minimally reproducible Cube Schema**

N/A

**Version:**

v1.3.24 thru v.1.3.47

**Additional context**

Nothing.

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.