Why can't I bring Jira field to confluence table?

Bill Mills March 31, 2021

I've created a table view in Confluence that displays fields as submitted via confiforms entries, including the Jira ID # that feeds back to the confiform entry at submission.   I wanted to bring the Jira Issue Status field into this field view as a separate field so I followed the following steps from vertuna:

"We add ConfiForms Field macros to the TableView and set the field names parameters like this:  myJiraIssue.fields.status.name".

This worked and I now have a separate field that I can export that lists status.   I want to do the same thing for another field labelled as "Sprint" (official name is customfield_15) and am unable to get it to work trying:

  • myJiraIssue.fields.sprint.name
  • myJiraIssue.fields.customfield_15.name

 

Has anyone run into a problem like this?

Appreciate any help / guidance!



1 answer

1 accepted

0 votes
Answer accepted
Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 31, 2021

What you need to know is exact name of the field and the structure Jira uses to return it's value when requested via REST API call

I am pretty sure the field name is not "customfield_15", as custom fields have a much larger numbers...

Try to do a request in the browser to

https://_your_jira_/rest/api/latest/issue/_issuekey_

Changing _your_jira_ and _issuekey_ respectfully, and see what field returns information about the sprint and what is the structure

Alex

Bill Mills April 1, 2021

You're right, it's customfield_10005.    I don't have global admin rights to my Jira server, just local project admin rights.   

Here is the field in xml:

<customfield id="customfield_10005" key="com.pyxis.greenhopper.jira:gh-sprint">

 

Does this help describe the issue better?  

Thanks!

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 1, 2021

Not quite. I have no idea myself how to get such xml

Have you tried to do a request as I mentioned in the browser?

(you don’t need any extra permissions)

find in that response your custom field and share its structure 

Bill Mills April 5, 2021

Unfortunately I get an error or redirected back to the main project page when I try to change the url.  

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 5, 2021

The URL you should craft should be almost the same as the one you see when you browse the issue - at least it's server part

https://_your_jira_/

Feel free to open support issue and provide the URL you see in the browser when viewing the issue in Jira and I will construct the URL fro you that does the same but returns a JSON (RESt API call)

Alex

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events