How can JIRA workflows be used in Confluence?

[Darryl Lucas]

I'm interested in using JIRA for workflowing Confluence pages through a review cycle. Can this be done?

[Nic Brough -Adaptavist- · Accepted solution]

No. They are systems which do two different things, and I'm not even sure how you'd envisage this working!

There is a plugin which does workflows in Confluence, but they're not as rich as Jira workflows (simply because the nature of the data in Confluence is very different to Jira). It does work rather well, but I've found you do need to put quite a lot of effort into it. https://plugins.atlassian.com/plugin/details/142

[Jim Birch]

You can run a sql query on the confluence db to get a list of pages that haven't been updated for (eg) a year. Something like the query bellow (I haven't tested this exact code)

If you wanted to you could pump the results into Jira using the command line tool but this might be overkill. Reviewers should put a "Reviewed: person/date" stamp at the bottome of the page to get them off the list. if the page really needed a rewrite you could maybe then create the Jira job.

-- Query to locate "expired" pages
select  -- top 100
 s.spacekey, c.TITLE, c.CREATOR, c.LASTMODIFIER, c.LASTMODDATE --, bc.body 
from
  dbo.CONTENT c
join
  dbo.BODYCONTENT bc
on
 c.CONTENTID = bc.CONTENTID
-- note: spaceid is null on old page versions so join on
-- space id selects only current pages.  Nice.
join
 dbo.SPACES s
on
 s.SPACEID = c.SPACEID
where
 DATEDIFF(day, c.LASTMODDATE, GETDATE() ) > 90 
order by
 s.spacekey, c.LASTMODDATE