Embedding specific Jira fields into a Confluence page

[Betty]

Hi, I have a Confluence page that I use to create a document that includes data from the Jira side. Currently, I have two windows open (one Jira and one Confluence), and I am manually copying Jira data and pasting into the Confluence page. I am required to check this long document quarterly and it is time consuming, not to mention puts a strain on my eyes. I tried looking in Macros to see if there's a Jira field I can use to specifically plug the Jira data I need in parts of the Confluence page so that whenever someone updates the data on the Jira side, this Confluence page is automatically updated as well. I apologize if I'm not using the correct terms.

Here's an example of what I'm trying to do in Confluence:

Requirement ID	Requirement Text	TWD Test Case
ABC-123 (This is a Jira ID)	Do Re Mi (This is the Jira description of the Jira ID)	DEF-456 (This is the linked Test Case under Jira Traceability)

[Varsha Joshi]

Hi @Betty_Corrigan 

Welcome to the community! I usually embed the jira link - that pulls the part of the description and status right to the confluence page. 

Maybe you already know this - by typing "/jiraworkitem" this pops up a screen to find the issues. I select "JQL" and provide the Jira id in the search box and select inline text.

I hope this helps and someone might suggest other creative ways to get that.

[Betty]

Hi @Varsha Joshi

Thank you for your rapid response, I sincerely appreciate it. I tried typing /jiraworkitem but nothing popped up. I did find this macro "Insert Jira Issue/Filter" and I think it may be the same as the "/jiraworkitem" pop up? For reference, this is what it looks like: 

I don't know what JQL is though. But I was able to find the Jira ID in the search box by typing "Key = Jira ID" in the Search box and have been able to insert the data that way in the Confluence page.

However, I've run into an issue with the final third column which is the linked Test Case(s) under Jira ID Traceability (see the table under my original post). Here's how I have it set up and this has worked for the previous two columns:

For some reason, it's not pulling the Traceability information for the Jira ID specified nor the Test Case(s) under the Traceability. This is what it looks like on the Confluence page:

Any suggestions will be greatly welcomed!

[Varsha Joshi]

You need put your page in edit mode, by typing "e" or click on the pencil on the top left page.

Then where you want insert the Jira you can start to type "/ji" the above pop up will show. Select Jira Work Items.

Upon clicking another pop up much like jira filter screen shows up 

Select JQL

#1 shows where JQL - click JQL

#2 is where you enter your JQL (Jira Query Language) the example I have shown is to pull just 1 jira item onto the confluence page. id=<yourJiraId)

#3 you want to select show as inline link.

then click on magnifying lens in the search bar

final step is to click on Insert Results button -> this should add Jira to your page.

[Betty]

Hi @Varsha Joshi 

So turns out we're not using Confluence Cloud haha. We're currently on Confluence DC so that's why your instructions doesn't show up for me. For me, "Jira Issue/Filter" is the equivalent to your "Jira Work Items". As for the Traceability not showing up in the second part of my earlier response, seems that I may need a Zephyr Scale macro as the Test Cases are a Zephyr Scale plugin.