to display release date of a version in jira project in confluence

Question

Can you please let me know if there is a way/option of displaying the release date of a version in a Jira project in confluence.

(All our projects in Jira have different versions associated with it, like a0, b0,....Each of these versions are associated with a unique release/due date.)

Is there a way to fetch the custom fields of Jira project and display it in confluence.

Brent Lewis · Answer

We use the JIRA road map macro gadget in Confluence to report on upcoming releases in Confluence. Works nicely and can be done for all projects or by project category

Bob Swift · Answer

One way is to use the Confluence SQL Plugin with some variation of this query:

select p.pkey, p.pname, v.vname, v.releasedate from project as p, projectversion as v where p.id = v.project order by p.pkey