KB30693: Cannot sort messages by clicking on the column header in History List Messages monitor in MicroStrategy

SYMPTOM:
In Strategy when the History List repository is configured as a database, a new monitor is seen under Administration ->System Monitors, called History List Messages Monitor.
However, users cannot sort messages by clicking on the column header in History List Messages monitor.
 
Note: The History List Messages Monitor is only available for Database Based History List.
 
For additional information database based History List and the new History List Messages Monitor, refer to the following Strategy Knowledge Base Documents below:

• KB20506 - New Feature in Strategy: Database Based History List
• KB20507 - New Feature in Strategy: History List Messages Monitor

STEPS TO REPRODUCE:
Follow the steps below to reproduce this issue:
 

• Configure a database based History List repository. Refer to the following Strategy Knowledge Base technical note for more information on how to do this:
   
  KB20508: How to set up and configure a Database Based History List Repository in Strategy
   
  
• Send several reports to History List.
• Log in to Strategy Desktop as an administrator user then go to Administration -> System Monitors -> History List Messages as seen below: 
  
  

• Click on any column header
• Notice that none of the messages can be sorted in any particular order.

CAUSE:
This is a limitation in Strategy Intelligence Server. An enhancement has been logged to addresss this in a later release.
 
ACTION:
Contact Strategy Technical Support for the latest status of this issue.
 
WORKAROUND:
Use Strategy DB Query Tool to query table DSSCSMSGINFO against the History List database directly using the following SQL:
Sql
SELECT *
FROM DSSCSMSGINFO 
ORDER BY ;