I have a question that uses a SQL view to gather data. This data is aggregated by date: week and is available from Sept 2020 to Sept 2021 and can be visualized on a line graph.
When clicking on a chosen point (let's say the first week of august) I am given the choice to view the related records. When doing so, "No results !" is displayed but if I choose to download full results as a csv for example, I can see the related records.
After doing some investigation, it appears that even if the data is visible from Sept 2020 to Sept 2021 in the table view or the line view, only the data from Sept 2020 to May 2021 can be "dug through". All data from May 2021 to Sept 2021 are just missing, except when downloading then as csv.
I have taken a look at the logs in the troubleshooting section but no errors is showing. The data is just truncated when zooming on the records.
Hi,
I upvoted.
Is modifying myself the limit in the query-processor constraints and rebuilding our own image while waiting for a fix (or a way to set this limit properly) a good idea ? Is there any drawback to that ?
@smarty Nested queries gets complicated and it's difficult to figure out performance problems for all types of databases, but you could try and monitor your database query log (or performance monitor) to see if it is causing any problems.