[BUG]: Calculated date field not respecting sort

Question

[BUG]: Calculated date field not respecting sort

Opened this issue 3 months ago · 5 comments

narimanshariat commented 3 months ago

SDK Version

1.6.4

Client Framework

React

Server Platform

Java

Operating System

Linux

Description

This is a column that is a calculated field and date formatted. It is clearly sorted but the sort is not taking into account. If a user clicks on the column header and hits sort it works. But by default it won't sort.

Answer 1 · 2024-06-10T04:23:29.000Z

As a note on the same visualization, I added another standard date field and used the sort and there was no issue.

Answer 2 · 2024-06-11T15:00:51.000Z

Hi @narimanshariat

Could you share what kind of datasource are you using in your code?

Another quick question.. are those fields of date type?

Answer 3 · 2024-06-11T17:31:42.000Z

Source is Postgres with datatype Date

Answer 4 · 2024-06-11T19:09:13.000Z

Thanks for your response.

We could reproduce it when a visualization is being edited and created an internal issue AB#31848

You will get any update here.

Regards.

Answer 5 · 2024-07-03T23:20:33.000Z

@narimanshariat As a workaround, while we take care of the issue, you can evaluate using a Pivot instead of a Grid. As long as you use a group of rows so that every tuple is unique, you should be able to get the desired output, while also sorting (since this issue is specific for Grid).