We are using the Custom Data Source API to retrieve data into Flexmonster. We are seeing an issue when our default layout form is Compact/Classic.
Given a Date field in the Rows/Columns with a simple aggregation in Values, no rows are returned. However, the grand total is correct and drill-through shows that all data was returned correctly. Both request and response seem correct.
With the same query, when we switch to Flat mode, all data displays as expected. Then, when we switch back to Compact mode, the rows display as expected.
When we run the same query with string/number data types in Rows/Columns everything works as expected.
Data being returned is the same for all modes. There is no difference in the response data in compact mode before and after the switch to flat mode.
Only minor changes were made to the sample .Net Core code provided on the Flexmonster site: https://github.com/flexmonster/api-data-source/tree/master/server-dotnetcore
We are using Flexmonster version 2.9.44. We tested with the latest version 2.9.104, and got the same results.
Thanks,
Rob (using Kunal's account)
Hello Rob,
Thank you for reaching out to us.
We could not reproduce the described behavior on our side. Could you please send us the report configuration (ReportObject) and sample data that we can use to reproduce the issue? This would greatly help us in continuing the investigation.
Looking forward to hearing from you.
Kind regards,
Nadia
Hi Nadia,
Please see attached for requested data and let us know if anything else is needed.
Thanks,
Rob
It seems we have found the root cause of this problem. In our custom data source API, ADO.NET detected our datetime fields as strings, thus our members endpoint was sending the data in the wrong format. Once we ensured the members endpoint was sending dates in the same format as the select endpoint, the grid started displaying the correct results.
Hello,
Thank you for the feedback!
We are glad to hear that you resolved the issue.
Do not hesitate to contact us if other questions arise.
Kind regards,
Nadia