Steps to reproduce the problem:
(1) Connect to SQL Server 2012 running at AWS
(2) Open the DBA Tools > Session Manager
(3) In Sessions tab, group sessions by Database
(4) Click Database column header to change sort order from none to ascending
--> Database tree nodes are displayed in ascending order
(5) Click Refresh button
--> Sort icon is displayed in Database column header but database tree nodes are NOT displayed in ascending order
All of ADS UIs which use similar objects probably all have this sort of problem.
Hi Fung -- how intrusive of a fix would this to be make in v17?
Fixed: SVN r45959/17.0.0-beta-21
All of UI objects presented here are jide specific objects. I debugged jide codes, it seems that in this particular scenario, the sort definitions are not passed down to the jide model object that is responsible for sorting; hence sort is not performed. I have no idea how to fix this problem.
After Refresh is clicked, all of tree nodes will be expanded. During the test, I noticed that if I clicked the 'Collapse All' button after Refresh, then tree nodes will be displayed in desired order. So, I made changes to programmatically 'Collapse All' followed by 'Expand All' after Refresh to work around the problem.
The problem described in this issue and the problem described in ADS #13748 probably is the side effect of the fix for ADS #5174. These problems probably are Session Manager specific because only Session Manager offers 'Group By' button. These problems likely can be reproduced in old ADS versions as well.
@Sachin,
Please let me know if you want to back port this fix to v16 or not. This is ADS #13748 related.
Fixed: SVN r45959/17.0.0-beta-21
All of UI objects presented here are jide specific objects. I debugged jide codes, it seems that in this particular scenario, the sort definitions are not passed down to the jide model object that is responsible for sorting; hence sort is not performed. I have no idea how to fix this problem.
After Refresh is clicked, all of tree nodes will be expanded. During the test, I noticed that if I clicked the 'Collapse All' button after Refresh, then tree nodes will be displayed in desired order. So, I made changes to programmatically 'Collapse All' followed by 'Expand All' after Refresh to work around the problem.
The problem described in this issue and the problem described in ADS #13748 probably is the side effect of the fix for ADS #5174. These problems probably are Session Manager specific because only Session Manager offers 'Group By' button. These problems likely can be reproduced in old ADS versions as well.
@Sachin,
Please let me know if you want to back port this fix to v16 or not. This is ADS #13748 related.
@Fung - yes, pls go ahead & fix it in v16 as well.
@Fung - yes, pls go ahead & fix it in v16 as well.
16.0.0 branch: SVN r45961/16.0.6-3
Manually merged SVN r45959 from trunk to ADS-16.0.0 branch.
16.0.0 branch: SVN r45961/16.0.6-3
Manually merged SVN r45959 from trunk to ADS-16.0.0 branch.
Verified in ADS 17 beta-22 & ADS 16.0.6-3.
Now session tree nodes are displayed in applied sorted order after refresh.
Verified in ADS 17 beta-22 & ADS 16.0.6-3.
Now session tree nodes are displayed in applied sorted order after refresh.
Issue #13751 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 16.0.6-3/17.0.0-beta-21 |
No time estimate |
Hi Fung -- how intrusive of a fix would this to be make in v17?