Automation/Copy Fields in Confluence

[erzn]

Hello everybody,

I would like to automate our Confluence and want to use it to document the EPICs in Jira. For this I have created a page in Confluence, which I would like to use as a template. I used inside a Template/Page the corresponding JIRA macros (standard jira macro).

Now, I want that the person who creates a new Confluence page of his EPICs to enter the Jira key (key of Epics) once and the script should fill/copy this key wherever a Jira macro is located on this page. Is this possible, or is there an extension for this?

Our Confluence Version is: 6.14.3

Thank you.

[Deleted user · Accepted solution]

So I'm not quite sure exactly what you mean when you say the script should copy the issue key. Copy the issue key where? What details? 

If I want Jira issue details in a Confluence page, you can add a macro that has the Jira issue/filter. Make sure you have application links set up. You would then create a filter in Jira that includes the epics you want, automatically. So it could be epics created in a specific project in the last 7 days, or with a label, or whatever. And then you insert the filter macro into Confluence, and then these epics will show up in Confluence as they are updated in Jira. 

Is that close to what you were looking for? Let me know if you want any more info.

[erzn]

Hi Devin,

Thank you for your reply. Meanwhile, I also searched a lot on system side and became aware of the blueprints. There is a template from Confluence called "Jira Report". When setting up this page, you first enter the project or the corresponding JQL. The Template then takes over this query and displays it in various variables (diagrams). That was what I needed - that just an input to the various jira macros (diagrams etc) transferred / copied within a page.

Now I have seen the possibility that you can edit this template. Can I just customize the page, add widgets / macros and this will be done automatically - or do I have to adjust something on the code as well? Is this so complex or is it sort of a WYSIWYG?

Ersin

[Deleted user]

Your Confluence version is a bit newer than mine (6.6.4), so the macros may behave a little differently. I have a macro called "Jira", which accepts a filter (JQL Query).

If it behaves the same way as "Jira Report", it will allow you to embed the Jira information into the Confluence page. You want to create a filter that will get the new epics each time the query is run. The macro runs the query/filter each time the page is loaded, so as long as you have a good query, you won't have to adjust the code. 

A basic query would be 

assignee = currentUser() AND resolution = Unresolved AND issuetype = Epic 

which gives you all of the incomplete epics assigned to you. If a new epic is assigned to you in Jira, you will see the issue pop up in Confluence if you have that query in the macro.

[erzn]

Hi Devin,

thank you for your kind response. Unfortunately that isn't what I'm looking for. I want to archive each project with its EPICs. And therefore I want to create a Database in Confluence with each project with its epics on each new page. I can't handle it if I have to adjust everytime the Jira-Macro.

But I know now where to start (on blueprints for Reports). I have to find some new help. Thanks anyway.

Best Regards