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
Release : 20.4 CU5 /CU6
OS:Win 2016
Database :MSSQL2016
Product Defect
This is resolved in UIM 20.4 CU7.
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)