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 jiraissueJOIN os_wfentryON jiraissue.workflow_id = os_wfentry.idWHERE os_wfentry.state IS NULLOR 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!

Hi Arama,Have you tried to perform the following Integrity Checker in Jira?Check Workflow IntegrityCheck workflow entry states are correctCheck workflow current step entriesCheck JIRA issues with null statusIt probably could help you resolve the workflow transition issue without performing the manual fix in database level.https://confluence.atlassian.com/adminjiraserver/using-the-database-integrity-checker-938847667.html

Community
Q&A
Jira
Questions
How to update all issues with transition state 0

Initiatives with linked epics that contain a specific field value

I have "Initiatives" where are connected to epics using the parent link field. There is a PI dropdown field (PI1, PI2, PI3...) in the epics.

Is the a JQL that allows me to find a list of only initiatives that are linked epics with a specific PI value?

2 answers

2 accepted

2 votes

Answer accepted

Hi Arama,

Have you tried to perform the following Integrity Checker in Jira?

Check Workflow Integrity
- Check workflow entry states are correct
- Check workflow current step entries
- Check JIRA issues with null status

It probably could help you resolve the workflow transition issue without performing the manual fix in database level.

https://confluence.atlassian.com/adminjiraserver/using-the-database-integrity-checker-938847667.html

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thank you.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

1 vote

Answer accepted

The integrity checker is built for finding and fixing these, amongst other things (Admin -> System -> Integrity check I think. But use the admin search if I'm wrong)

With ScriptRunner, there may be several things that you need to fix on your broken issues, the integrity check should handle them all for you.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Initiatives with linked epics that contain a specific field value

2 answers

2 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events