Hello Helical Team,
hello, I am using helical insight enterprise edition 4.1 GA. By default when a tabular report gets created it only has got 10 records. I would actually like it to have more number of rows. Is that possible?
Thank You,
Sesa.
Hello Sesa,
By default whenever a tabular report is created a pagination happens with the usage of limit and offset clause so that it only loads 10 records and meanwhile it keep on uploading more and more no of records. This is basically done to improve performance.
But by putting the below code at the JSeditor you can specify how may records should open. In the code you can specify how many rows you would like to appear. In the array you can also specify how many options can be there at the search at the top of tabular report but then the number of rows will be the first element in the array only though.
hi_container.set(“preExecution”,function( c) {
var viz_Options = c.get(“viz_Options”);
viz_Options[“rowCount”] = [25,50,75,100];
c.set(“viz_Options”,viz_Options);
});
Thank You,
Helical Insight.