+2
On APPS9.
Trying to display a 12 month trend in a line-chart. There are data-points for each day and the element size is set as 4x2 (shouldn’t matter). When running the lobby data is shown for ~4months then it cuts the time-line.
What is the limiting factor for this in line chart elements?..
Can the line elements only handle 4months (~120 days) of data? Seems a bit limiting if that is the case..
Hi,
I found a similar issue - when I ran the debugger in IFS I noticed that the SQL query had been changed to only fetch the first 100 rows when using a line graph element.
The graph was therefore missing quite a few entries.
Did you manage to find a solution for this?
Kind Regards,
Dan
+13
Hi Both,
From what I have seen in lobbies, it is true that “FETCH NEXT 100" is added to the query when you debug, and the main reason behind this is to avoid performance issues. Most of the lobby element types are designed to provide a high-level overview of the data, hence won’t show the full set of a huge data pile.
This limitation has been intentionally actioned as this will avoid the rendering issues in using lobbies.
As a suggestion, you can use list elements to display huge data sets.
Hope the above helps!
Cheers!
Novishan
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
