Hi,
We recently had some space problems, which caused new issues created to be created without workflow transitions.
I can identify all of them by doing:
SELECT *
FROM jiraissue
JOIN os_wfentry
ON jiraissue.workflow_id = os_wfentry.id
WHERE os_wfentry.state IS NULL
OR os_wfentry.state = 0;
in the database.
I would update all of them to a proper workflow state through the DB, but that requires downtime we cannot afford.
Is there a way to automatically update all the issues os_wfentry.state to 1, using Scriptrunner's console perhaps?
Thank you!
