How to handle widget configurations after added new column in data source query

When working with Bold BI dashboards, it’s important to understand how widget configurations are handled, especially when making changes to the data source query. This article will guide you through the process and help you avoid common pitfalls.

Understanding Widget Configurations

In Bold BI, widgets are configured based on the fields in your data source query. If you add new fields to an existing query, the existing fields and their corresponding widgets will not be affected. However, if you modify the alias name of an existing column in the query, the corresponding field will be removed from the widget. This is the current behavior of BoldBI to handle widget configurations.

Example Scenario

Let’s consider a scenario where you have a query with ‘Id’ and ‘Date’ fields, and widgets configured with these fields.

If you add a ‘Name’ field to the query, this won’t affect the existing widgets. The ‘Id’ and ‘Date’ widgets will remain as they are.

However, if you modify the ‘Id’ field with a different name, the specific field will be removed from the widget. This is because the alias name is used for validation, as there are chances of changes to the field name in the table.

Recommendations

Even if the column name is modified in the database, we recommend you to modify the column name in the query but leave the alias name as it is. This will ensure that your dashboard retains its current configuration and prevents any unwanted changes to your widgets.