Dynamic text in confluence from JIRA

[Kevin Shine]

Hi

I am trying to create a page template in the new confluence something like this:

<th>Jira Number</th><th>Summary</th><th colspan="1" width="">Work Status</th><th colspan="1" width="">Date Started</th><th colspan="1" width="">Date Resolved</th><th>Risk</th><th>Notes</th>

$UserEnteredJiraNoRow

{getJiraData:$UserEnteredJiraNoRow,Summary}

{status description={getJiraData:$UserEnteredJiraNoRow,status} color=getJiraData:$UserEnteredJiraNoRow,RagStatus} }

{getJiraData:$UserEnteredJiraNoRow,DateStarted}

{getJiraData:$UserEnteredJiraNoRow,ResolutionDate}

High/Medium/Low

Some notes go here

I want the users to be able to add rows to the table and populate the JIRA Number Field, the risk field and the notes field. I want the text in Summary,date started and date resolved to be pulled from the JIRA issue itself.

I don't want to use the JIRA macro plugin as its not really what I am trying to do as you can see by the above table and code sample.I made up the getJiraData to try and show what I am trying to do. Hope it makes sense.

I am new to Confluence, but this seems like a rather obvious and missing feature....or am I missing something.

Is there a 3rd party plugin that can do this? Seems odd that confluence cant do this.

[Adrien Ragot 2]

Hi Kevin,

The closest is to use the JIRA List, and you'll be able to select columns. Of course, you're asking to be able to comment on each row, and this is not currently possible. I'm not aware of plugins which can do that.

The way we usually work is:

• Plan workloads and estimates (at the smallest scale) in JIRA Agile:
  • Start a Sprint (1-week or 2-weeks period, see "Scrum" projects in JIRA),
  • Evaluate each issue in "points",
  • Move the bar so the sprint contains the right number of points for the team capacity,
  • Instead of estimating due dates on a page, discuss them during the team meeting and make them fit into a Sprint.
• To plan bigger projets: There are a few plugins on the JIRA side which let you create Gantt diagrams and estimate workloads.

As a conclusion, we don't usually feel the need to pull fields from JIRA because we mostly use Confluence for high-level requirements or detailed design, and we move to JIRA for "estimation" activities.

Cheers,

Adrien