Custom macro - start and end date of the issue to be displayed on a Confluence page

[Anna O.]

Hi everbody, 

we want to display start and end date of a project on a Confluence page (while this data is all in Jira). 

• Does anyone use it like this?
• We got a recommendation to build a custom macro with Scriptrunner, but since I am new to programming, should someone help me with the code block?

Thanks a lot!

Best, Anna

Here is what the support of Scriptrunner recommended:

I believe the best path forward would be to create a Custom Macro that interacts with the Jira API, specifically the Get Issue Endpoint, to retrieve your desired Jira issue properties and the present this information within a table, which you can create following the example here! 

[Davin Studer · Accepted solution]

If you simply want to display some fields from an issue in Jira in a tabular format you should use the Jira macro. You supply the macro a JQL query or filter and then tell it what fields you want to display in the resulting table.

[Anna O.]

Hi Davin, 

thanks to your proposal!

Start and end date of an issue are in our case custom fields. So I dont see any possibility right now to display custom fields in Confluence. Or do you know how to do it?

As far as I can see, there are available colums: key, summary, issue type, created, updated, due date, assignee, reporter, priority, status, resolution --> please compare the screenshot.

Thanks in advance!

Best, 

Anna

[Anna O.]

Here is for example the filter I created "Start Date" is not EMPTY AND "End Date" is not EMPTY AND issue = TS-507

[Davin Studer]

The columns to display initially shows some pre-populated fields but you can change it. The "x" next to each field will remove it and if you place your cursor  at the end of the list and click you can add fields ... even custom fields.

[Anna O.]

Thanks a lot David! This I did not know. You are awesome!

[Karen Hayden]

Using the Jira Issue/filter on a Confluence page and adding Custom Fields to the 'Columns to display' box, displays the column header but not the data. (When there is data present on the Jira.)

Is this a new bug?  Or any suggestions to resolve?