Reason for change

Change query to take into account database schema changes introduced by ISOC release 4.4.
These changes caused the production application to either hang or crash.
Additional small fixes have also been added.

Test Procedure

The new query has been tested on the development server.

Rollback procedure

Version 0.1.1 can be easily put back in place.

CCB Jira

SSC-11@JIRA

Details

type key summary assignee reporter priority status resolution created updated due

Unable to locate Jira server for this macro. It may be due to Application Link configuration.