Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Is it possible to query Portfolio progress info like Completed and Remaining from Jira/JQL?

When hovering progress bars for initiatives or Epics in Portfolio for Jira Cloud a note appears that displays Completed Story Points and Remaining Story Points.

I would like to be able to export these fields from Jira Cloud (or Scriptrunner Cloud) either via the Jira Cloud for Sheets, a REST API or display them in a Jira filter which I can export in Google Sheet or Excel.

Is this possible at all?

2 answers

1 accepted

0 votes
Answer accepted

Hi @Matthieu B. 

Answering your question here as well,  Jira Portfolio doesn't currently expose API where its Data can be accessed Programmatically. On the other side, using the Jira Cloud REST API would only return already committed data. However scenario data cannot be accessed via API at the moment.

Secondly in future, there might be plans for a Portfolio Specific API but nothing currently on a short term plan backlog. Furthermore about the Jira Cloud add-on for Google Sheets, due to the constraint from Portfolio not having an exposed API there wouldn't be any practical way for the Add-on to be able to extract Portfolio specific scenarios but on a longer term it depends on such demands and technicalities involved in getting such feasible, so we're not able to say as of now.

Hope the above helps.

Cheers,

Prince.

Hi Matthieu,

Thank you for your question. 

I can confirm that it is not possible to generate an export of these fields to a spreadsheet using ScriptRunner for Jira Cloud,due to the fact that Atlassian do not provide a rest API to generate an export file inside of Jira Cloud and that ScriptRunner for Jira Cloud can only use the rest API's which Atlassian Provides.

I can confirm that you can see further details on the differences between ScriptRunner for Jira Cloud and ScriptRunner Jira Server for your reference inside of the documentation page located here.

If this response has answered your question can you please mark it as accepted so that other users can see it is correct when searching for similar answers.

Regards,

Kristian

Thank you @Kristian Walker _Adaptavist_ , after re-reading my question your reply probably answers 99% of what I wrote, but only 80% of what I had in mind - and I believe you speak for Adaptavist (ScriptRunner) not for Portfolio/Atlassian

So before closing this question, could you also help with the following or help to get a Portfolio community leader involved (assuming I posted this question in the Portfolio section of the Atlassian community correctly)?

  1. Is the ad-hoc / one-off export function the only way to get this data out of Portfolio e.g. no other Portfolio specific API is currently available?
  2. Is there any plan/discussions at Atlassian to either make a bespoke Portfolio API accessible OR to extend the (amazing) Jira Cloud for Sheet add-on so we can query individual fields from Google Sheets without having to manually export and re-import a whole Portfolio dataset?

Many thanks for the extra info...

Hi Mattheiu,

You are correct, my response is based on the Atlassian Cloud Rest API's and ScriptRunner for Jira Cloud.

I am unable to say if Jira Portfolio contains any built in functionality to achieve your requirement as I am not familiar with how Jira Portfolio works myself.

I would advise asking this question to Atlassian directly at https://getsupport.atlassian.com in order to ask them directly if Jira Portfolio can achieve your requirements.

Regards,

Kristian

Support ticket created: JST-505584.

Will post answer here unless Atlassian Support updates this thread directly.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

324 views 9 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you