Grid "flat form" is empty and broken when data contains year/quarter/month/day type

posted on January 22nd, 2019

Closed

Projet TCD asked on January 22, 2019

Version: Pivot Table for JSON data sources 2.6.12 (Jan 14, 2019)
Browser: Chrome 71.0.3578.98 on MacOS 10.14.1
Link to reproduce: http://jsfiddle.net/34aeuhwm/
Steps to reproduce:
- Display pivot table
- See result of "Total Count of Group" is displayed properly
- Click on Toolbar > Options > Flat form
- Click on Apply
- See grid

Observed behavior:

Result is incorrectly displayed (no data, or empty grid)
Grid is now misaligned and cannot be manipulated (selection, resizing of columns, etc)

Error in Chrome JS console:

flexmonster.js:9 Uncaught TypeError: Cannot read property 'members' of undefined
    at j9C.ZD (flexmonster.js:9)
    at j9C.getData (flexmonster.js:9)
    at y4y.e9C.getDataFunction (flexmonster.js:9)
    at y4y.getData (flexmonster.js:9)
    at F5m.i98.xd (flexmonster.js:9)
    at M68.Bh (flexmonster.js:9)
    at M68.H1y.Tk (flexmonster.js:9)
    at M68.Aa (flexmonster.js:9)
    at F5m.i98.qy (flexmonster.js:9)
    at F5m.qy (flexmonster.js:9)

Expected behavior:
- Pivot produces a result in flat form when one or more fields have a type "year/quarter/month/day", independently of their order in the data/configuration.
Workarounds:
- Changing "type" in the JSON data headers from "year/quarter/month/day" to "date" solves the issue (value and no error in console) - Not acceptable since the point is to use the type "year/quarter/month/day"
- Moving the field of type "year/quarter/month/day" to the last position in the JSON data headers (and changing the order for the data) also solves the issue (value and no error in console) - Not acceptable when data and headers are created dynamically (no control on the order of the fields)
Notes:
- Similar to https://www.flexmonster.com/question/distinct-count-is-incorrect-and-grid-is-broken-when-using-a-field-of-type-yearquartermonthday/

Attachments:
screen_01.png

3 answers

Public

Dmytro Zvazhii ⋅ Flexmonster ⋅ January 22, 2019

Hello,
Thank you for writing to us.
We have managed to reproduce the issue on our side.
The necessary fix will be released in the version with ETA Feb 25.
We will keep you updated.
Regards,
Dmytro

Public

Iryna Kulchytska ⋅ Flexmonster ⋅ February 27, 2019

Hello,

I'm glad to inform you that the version with the fix has already been released.
Please feel free to update the component.

Let us know if everything works fine for you.

Kind regards,
Iryna

Public

Projet TCD ⋅ April 2, 2019

Hello, thank you for the fix. The most urgent part of the issue seems fine (breaking the grid), but the disctinct count still isn't correct.
I've reported the issue with new reproduction steps here: https://www.flexmonster.com/question/distinct-count-is-incorrect-when-using-a-field-of-type-year-quarter-month-day-or-year-month-day/

This question is now closed