Description:
The Project Risk, Issue and Change Summary report query joins the SRM_RESOURCES table at the wrong field. It is pulling from the ID field opposed to the USER_ID field for the 'Assigned To' column. This causes the resources names showing on the 'Owner' column on the report to be inaccurate.
Steps to Reproduce:
Expected Result: 'Risk A' shows Resource1 on the 'Owner' column
Actual Result: 'Risk A' shows a different Resource on the 'Owner' Column
Solution:
Workaround:
Copy the existing report, and create a brand new report with this slight change in the code:
On the Project Risk Issue and Change Summary report query, look for this line:
LEFT OUTER JOIN srm_resources own ON r.assigned_to = own.id
It needs to be changed to this:
LEFT OUTER JOIN srm_resources own ON r.assigned_to = own.user_id
This also affects the Project Risk Register and Project Issue Register reports in Clarity 13.3. The same workaround applies to these two reports using their corresponding queries.
Status/Resolution:
This issue is documented as CSP-158 and affects CSP 3.3
Resolved in Clarity 14.1 Solution Pack (CSP)