Remove Completed/Cancelled Trade Request From Dashboard

Remove Completed/Cancelled Trade Request From Dashboard

Issue:
Completed/cancelled Trade Request still appear on the dashboard.

Root Cause / Findings:
Trade Request task status not updated accordingly to Trade Request latest status causing the task still appeared on the dashboard.

Resolution:
Get the task id of the trade request by right click the task hyperlink on the dashboard and select properties.


Copy Address (URL) and paste to notepad.




Sample of SQL query to update the task status :
UPDATE I_TBLTASK
SET Status = ‘Cancelled’
WHERE taskid = ‘255145’
AND Status = ‘In Progress’