Custom Datasource API - /select requests for Flat Tables involving dates

Re-Open
Henry asked on March 30, 2021

Hello,
 
We had the following observation that we were not sure of. When we have dates configured in the report and the layout is that of a Flat Table, we noticed that in the /select call, there is request for the count of the dates. However, if the layout is that of a Compact View, then the /select call does not contain a request for the count of the dates. Is this the expected behavior? If so, what is the purpose of requesting the count of the dates when the layout is a Flat Table, but not when it is a Compact View? We've prepared a jsFiddle and some screenshots for convenience.

 
Please let us know if you need further details and/or clarifications!
 
Kind regards,
Henry

3 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster March 31, 2021

Hello, Henry,
 
Thank you for reporting this observation.
 
On the screenshot dedicated to the compact form, the date type field is placed in rows. The aggregation is only needed for fields set to measures. This behavior is expected.
 
Still, the count aggregation for the date field on the flat form seems to be redundant.
Our team will research this question and get back with results ETA May 03.
 
Feel free to contact us in case any other questions arise.
 
Kind regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 5, 2021

Hello, Henry,
 
We are happy to let you know that the issue with the unnecessary “date” field aggregation request in the flat view was fixed.
 
This is available in the 2.8.32 version of Flexmonster: https://www.flexmonster.com/release-notes/.
 
You are welcome to update the component.
Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
 
Please let us know if everything works fine for you.
 
Best regards,
Illia

Public
Henry May 5, 2021

Hello, Illia,
 
Upgrading to 2.8.32 looks to have fixed the issue. Much thanks to you and the team!
 
Kind regards,
Henry

Please login or Register to Submit Answer