Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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 Advanced Roadmaps

3 short videos to help you get started with Advanced Roadmaps

Hi community, I’m Roi, a product manager working on Advanced Roadmaps for Jira. While Advanced Roadmaps is a powerful tool to plan and track work at scale, we know it can be challenging to get star...

3,802 views 24 15
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