How can JIRA workflows be used in Confluence?

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

2 answers

1 accepted

1 vote

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

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


Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Monday in Confluence

Calling all marketing teams who use Confluence - we want to hear from you!

Hi Community! me again 🙂 If you’re a marketing team using Confluence, we want to hear your story! How did you start using Confluence? What are your use cases? What have been some of the benefits?...

226 views 3 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you