Workflow Integrity Check needs an additional check

XMLWordPrintable

      You need to account for the case where the jiraissue.issuestatus is null.

      We had quite a large number of these - and in all cases, the worflow status was ok - so it was just a matter of updating jiraissue with the value from OS_WFENTRY

      REPORT:

      SELECT     jiraissue.pkey, OS_WFENTRY.STATE, jiraissue.issuestatus
FROM         jiraissue INNER JOIN
                      OS_WFENTRY ON jiraissue.WORKFLOW_ID = OS_WFENTRY.ID
WHERE     (jiraissue.issuestatus IS NULL)
ORDER BY jiraissue.pkey;

      FIX:

      update jiraissue
set    issuestatus = ( select state 
                       from   os_wfentry
                       where  id = workflow_id )
where  issuestatus is null;

      And pls make it efficient (no N+1 database calls...) - the other integrity checks are quite slow because of inefficient database access...

              Assignee:
              Dylan Etkin [Atlassian]
              Reporter:
              Nick Minutello
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: