UIM dashboard sql table widget number sort is incorrect

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)

Issue/Introduction

When creating a dashboard with the "sql table" widget and in the table we have also a column with numbers, this column is sorted incorrect when we click on the column title

Environment

Release : 20.4 CU5 /CU6

OS:Win 2016

Database :MSSQL2016

Cause

Product Defect

Resolution

This is resolved in UIM 20.4 CU7.

 

Additional Information

Notes:

•  For this fix to work, please set the Column Data Type of the numeric value to "number" from Dasbhboard Designer Wizard > widget properties then save it to make it persistent. 

 

•  The attached upm_dahboard.20.4.6-t1*****.zip was also tested to resolve the issue on top of UIM 20.4CU6 

 

Related KB:

20.4 CU6 dashboard "sql table" widget sort order lost with refresh (broadcom.com)