sql widget in dashboard designer - how to add columns

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

In Dashboard Designer we are using the SQL Table Widget but unable to determine how we can add columns.

The table only shows two columns, but I do not see any Add Column button like we have on List Widget.

How can I add columns?

 

Environment

Dashboard Designer - Any Version

Resolution

For SQL table widgets in the Dashboard Designer, you do not need to specify a number of columns.

Once you create a query and link it to the widget, the number of columns will be automatically set to the appropriate number based on how many columns the query returns.

So if the query in your SQL Datasource returns, e.g. 5 columns, the widget will automatically expand to 5 columns to accommodate the results.

Additional Information

See the following documentation for more details on assigning data sources to widgets including SQL Data Sources:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/20-4/configuring-and-viewing-monitoring-data/the-dashboard-portlet/create-and-assign-the-data-source-for-a-widget.html