nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to port a date field from Jira to a Confluence table using Confiforms Field macro?

Bill Mills

I have 2 fields that I currently bring into a Confluence table using this method.

The first one is the 'status' field which is done using this as the field name:

JiraIssue.fields.status.name

The second one is the 'sprint' field, which is done using this as the field name:

JiraIssue.fields.resolutiondate.greenhopperAsJSON.name

Neither of these formats work for bringing in the resolution date field (resolutiondate) into the table.

Is this possible using a different format in the field name?

Thanks!

Accepted answers

All comments

Alex Medved _ConfiForms_

Hi @Bill Mills

Do you have a resolutiondate in the JSON returned by Jira?

What format/value does it have?

Alex

Bill Mills

Hi @Alex Medved _ConfiForms_ thanks for the quick reply. It has datetime format. It's the system generated timestamp field for when issue resolution is set by a status change. Thanks!

Alex Medved _ConfiForms_

Could you share exactly how it looks like and what do you want it to transform into?

Bill Mills

I can't show the coding, I'm a complete amateur when it comes to that side, and I rely heavily on existing set up. I don't want to transform it in any way, just show the datetime value from a field called "Resolved" into a Form Field macro so that the date shows in a Tableview macro.

I was able to refer to our Jira field reference table that has info about the field, and it shows as a non-custom field that is not orderable, but it is navigable and searchable (if any of that info helps). Field type is 'datetime' and the ID is 'resolutiondate'.

Does this help?

Alex Medved _ConfiForms_

I don’t think I understand this.

Have a look at this page https://wiki.vertuna.com/display/CONFIFORMS/Accessing+Jira+issue+fields+directly+from+ConfiForms+using+Jira+issue+field

could you get the json response from Jira to see how it looks like? Especially the part for the resolutiondate

Alex

Bill Mills

Sorry I'm not sure how to find the json response. I administer a project only at the project level; I don't have access or permissions to do or see much in the back-end.

In the link you shared, there is a section that shows exactly what I've already done with 2 other fields, using a Tableview macro. I already have the jira issue key as the first field on the tableview. The jira key field is called "fldJiraIssue".

The 2 fields I'm already bringing into the tableview are:

Field 1 - field ID: status - field name: status - field type: status

I bring this into my Tableview macro using another Confiforms Field macro, using this parameter for field name: fldJiraIssue.fields.status.name.

Field 2 - field ID: customfield_10005 - field name: sprint - field type: array

I bring this into my Tableview macro using another Confiforms Field macro, using this parameter for the field name: fldJiraIssue.fields.customfield_10005.greenhopperAsJSON.name.

New field I want to add - field ID: resolutiondate - field name: Resolved - field type: datetime

I've tried both syntax set-ups that are used in Field 1 and Field 2 examples, but neither works. I'm guessing it's the syntax used in the parameter, because it's a different field type (this is the case for field 1 and 2, since they each have different parameter syntax and different field types.

Appreciate your patience as I try to explain!

Alex Medved _ConfiForms_

Open the browser, go to this URL (substituting the YOUR_SERVER and YOUR_KEY)

https://YOUR_SERVER/rest/api/latest/issue/YOUR-KEY

And see what response it returns

Find the resolution date field and see it's format and location

Bill Mills

Unfortunately I don't have access to this. I get a message advising me so. I'll see if the IT team who administers the server may be able to provide it.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

confluence

data-center

confiforms

confluence-data-center