Changing the sort order of the My Team Performance Task List in WebSphere Lombardi Edition (WLE)

Large Task Lists in your My Performance and My Team Performance reports often require there to be a consistent, or customized sort order applied. You can find the query that handles this Task List in the 60Database.xml configuration file:

<task-details-query>
     select
         task.task_id, task.subject,
         varchar_format(task.due_date + {3} SECOND,''MM/DD/YYYY''),                         forUsr.user_name,forUsrGrp.display_name as group_name, priority.name,
               coalesce(
                   (select 1
                    from lsw_usr_grp_mem_xref ugm
                    where
                       ugm.group_id = forUsrGrp.group_id
                       and ugm.user_id in ({0})
FETCH FIRST 1 ROWS ONLY),
                    coalesce((select 1 from sysibm.sysdummy1 where task.user_id in ({0})), 0)
               ) as runnable,
          bpd_instance_id, fromUsrGrp.display_name as group_name
      from
          lsw_task task left outer join lsw_usr_xref forUsr on task.user_id = forUsr.user_id
          left outer join lsw_usr_grp_xref forUsrGrp on task.group_id = forUsrGrp.group_id
          left outer join lsw_usr_grp_xref fromUsrGrp on task.group_id = -fromUsrGrp.group_id
          left outer join lsw_process process on task.cached_process_version_id = process.version_id
          left outer join lsw_priority priority on task.priority_id = priority.priority_id
      where
          task.task_id in ({1})
</task-details-query>

To apply a sort order, complete the following steps:

1. Add the following code (including the latest query from either the 60Database.xml file, or any newer Fix Pack configuration file) to your 100Custom.xml file:
   <properties>
    <server merge="mergeChildren">
      <portal>
        <report-integrations>
          <task-details-query merge="replace">
            ... [INSERT QUERY HERE] ...
            order by user_name,group_name,due_date asc
          </task-details-query>
        </report-integrations>
      </portal>
    </server>
   </properties>
   
   
2. Restart your server and the changes will take place.

Note: To ensure that your configuration changes have taken place, after you restart the server, you might search through the TeamWorksConfiguration.running.xml file for the <task-details-query> tags. If the query within this file has your "order by" line, the changes were synchronized across all of the nodes successfully.