We were looking at a way of bulk closing a large number (1000+) issues via MySQL (changing the issuestatus etc), the issue itself updated fine but when we do a filter or a search for the issue then it hasn't updated.
We have now changed all the colums in the jiraissue table back to their original, but now if I change anything in the issue itself, the filter doesn't reflect the changes (such as changing the assignee, the status, etc etc)
Is there anyway I can completely remove the issue from the system (as it's only a test issue) I tried removing the row from Mysql (jiraissue table) but it removes the issue, but it still shows in the filters and searches.
Thanks
