I am pretty new to JQL. I've been trying to get all the issues (type: Initiative, super-initiative, epic & story) that are part of a portfolio-plan. I've been able to do the same for projects but not able to get the same work for portfolio. Appreciate any help from the community, thank you!
As of Portfolio for Jira 2.11 you can search for all issues in a plan or a program like this:
All issues in a Portfolio Plan
issuekey in issuesInPlan(54)
where the number '54' is the unique id of your portfolio plan. The ID is shown in the url of your plan.
All issues in a Portfolio Program
issuekey in issuesInProgram(30)
where the number '30' is the unique id of your portfolio program. The ID is shown in the url of your program.
For more details on searching Portfolio related data through JQL, see Atlassian documentation
Thank you for your response. I get "Unable to find JQL function 'issuesInProgram(18)'." error when I execute this query. This is the URL that's generated when I click on the portfolio "secure/PortfolioPlanView.jspa?id=18&sid=17#backlog". Do I need to enable any settings for my user?
Hi @Ashish Yadav,
Just a couple of things I can think of:
The issue was with the version of Jira portfolio we were using. We upgraded to the latest version for Jira portfolio and the query are executing successfully. Thanks a lot for your help with this.
I had another question though. When I execute the query using a API connector, that supports JQL (DOMO), the results returned by the query is api field names and not the actual label that I see on Jira server. Is there a way for me to extract that information. Thank you!
To see this feature in action check out our recent dependencies demo here: https://www.youtube.com/watch?v=eQu5VsUqyZA Keeping on top of your dependencies is a key part of ensuring project success....
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