Remove Dead Worklist Entries

I want to remove worklist entries which have dead links.

But they only gave me a screenshot of the worklist page.

1. Get OPRID of recipient
2. Get OPRID of sender. If you look at the screenshot, it's the guy under FROM column.
3. Get EOAWTHREAD_ID. If worklist is delivered, look at the 2nd value of the Link column.
4. Execute SQL below.

SELECT A.BUSPROCNAME, A.ACTIVITYNAME, A.EVENTNAME, A.WORKLISTNAME, A.INSTANCEID, B.TRANSACTIONID, B.INSTSTATUS, 
(SELECT C.XLATLONGNAME FROM PSXLATITEM C WHERE C.FIELDNAME = 'INSTSTATUS' AND C.FIELDVALUE = B.INSTSTATUS) AS INSTSTATUS_XLATLONGNAME
FROM PS_EOAW_WL A, PSWORKLIST B
WHERE A.BUSPROCNAME = B.BUSPROCNAME
AND A.ACTIVITYNAME = B.ACTIVITYNAME
AND A.EVENTNAME = B.EVENTNAME
AND A.WORKLISTNAME = B.WORKLISTNAME
AND A.INSTANCEID = B.INSTANCEID
AND B.OPRID = [recipient here]
AND B.ORIGINATORID = [sender]
AND A.EOAWTHREAD_ID = [eoawthread_id]
ORDER BY A.EOAWTHREAD_ID;

Now you have the INSTANCEID and TRANSACTIONID.

Set INSTSTATUS to Cancelled.

UPDATE PSWORKLIST 
SET INSTSTATUS = 3 
WHERE INSTANCEID = [instanceid] 
AND TRANSACTIONID = [transactionid];