Platform 8.14.12

New features

Suggestions

Many of the Activeboards users create have performance issues because they are not optimized for proper operation. The idea is to develop a suggestion package that identifies these common ways of improvement in the configuration of widgets and queries. To do this, certain rules could be defined that allow suggesting and applying optimizations.

The proposal is to develop a module that contains the definition of all the rules, the implementation of each one of them and that allows offering a response with all the suggestions that can be applied for the input parameters offered.

The following initial rules have been proposed to suggest them:

Unused Columns → Inform when a column from a query is not used in the chart configuration. This is check the query metadata and check the configurations for the widget and compare the columns used.
Unnecessary Time Grouping → Inform when a query have a grouping time but the charts doesn’t need it.
Duplicated Column → Inform when there are two columns with the same name. Normally, this happens when user have grouped by a column and then add a select statement for the same column without the as statement

Another existing rule has been moved also to suggestions:

Generate aggregation task → Inform when a query can be optimized by an aggregation task.

This suggestion already existed in the widgets when an aggregation task did not exist and query was prepared for that. This suggestion was shown with the rocket icon.

This icon is deprecated now and functionality moved to Suggestions.