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

This widget could not be displayed.

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

This widget could not be displayed.

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
Community showcase
Posted Sep 17, 2018 in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

547 views 7 6
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