JQL to find issues in a Portfolio Plan

Scott Clem

I'm trying to write a JQL query to pull all the issues in a Portfolio Plan.  I know I can manually run an export, I just prefer a JQL query, because I can query exactly what I need.

There is a solution mentioned in this article:

 

https://confluence.atlassian.com/jiraportfolioserver/searching-for-issues-using-portfolio-details-940678957.html

For issues in a specific plan

• To search for issues in a specific plan, type issuekey in issuesInPlan(54), where <strong>54</strong> is the unique ID of the plan.
• For example, you have this URL for your plan:
  <a href="https://teamsinspace.atlassian.com/secure/PortfolioPlanView.jspa?id=54&sid=68#backlog" rel="nofollow noopener noreferrer" target="_blank">https://teamsinspace.atlassian.com/secure/PortfolioPlanView.jspa?id=54&sid=68#backlog<br></a>The plan ID in the URL is 54.
  

BUT it does not seem to work for the cloud version of Portfolio.  The function IssuesInPlan returns the error when running a JQL query:

 

Unable to find JQL function 'issuesInPlan(29)'.

 

Am I missing something or is there another way to accomplish this?

 

 

Sachin_q0v8o8

Hello Scott, 

You are correct, the JQL options are not available on cloud, here is an open ticket with atlassian - JPOCLOUD-7620

I am not aware of any workaround at the moment, but here is the documentation for Cloud version Searching for Portfolio for Jira custom fields in JQL

Best,
Sachin.