Development Status Field not showing up in Confluence Jira Issue Report

[Steve Morris]

I have created a confluence page containing a Jira Issues List macro.   In the columns to display field I have added the Jira System field 'Development', which I assume should include the status of the latest branch related to that issue, i.e. branched, merged, etc.

I know that the issues in the filter I am using have Development statuses but they aren't included in my Confluence macro. 

 

 I am using Confluence Data Center 6.12.0 and Jira Data Center 7.12.1

[Moga]

Hi Shikha,

We can use the SQL from How to List all the Issue Status Transitions for Past x Days with Issue Key from Database in JIRA.

The SQL should be something like:

SELECT project.pkey, jiraissue.issuenum, changeitem.oldstring, changeitem.newstring, changegroup.author, changegroup.created 
FROM changeitem JOIN changegroup ON changeitem.groupid=changegroup.id 
JOIN jiraissue ON changegroup.issueid=jiraissue.id JOIN project ON jiraissue.project=project.id 
WHERE (project.pkey= 'FPS' and changeitem.field='status');

I hope that this helps. 

Cheers, 
Mogavenasan