Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Using Jira queries to populate Portfolio


I am trying to limit the stories that populate in Portfolio by loading a board that is populated by a filter that pulls multiple projects into one board based on epic criteria. When I look at the board in Jira the data is correct but when I pull that board into Portfolio it no longer limits the data from that board that is filtered by my query. Here is the query that I use to populate the board "issue in epicsWhereIssueIn("project= medical") AND project != medical" but when I open portfolio it list every story from all the projects that populate that board when I just want the epics. Any help is greatly appreciated. Here is another example of a query that I cannot get to populate correctly in Portfolio: project in (auto, casualty, medical, siu, ss, property) AND type = epic AND issue in epicsWhereIssueIn("project = FLEX")

1 answer

0 votes
Crystelle S Community Leader Dec 18, 2019

Question - issue in epicsWhereIssueIn("project = FLEX") - is this an add-on? At the conference class this year I asked about using scriptrunner add-on queries in Portfolio and Atlassian admitted they saw issues with nested queries from that particular add-on. It's possible that Portfolio is also having issues with your add-on. Not an answer per se but may be why you are seeing what you are seeing. I've gotten around this issue by splitting out the queries and pulling them in individually when building a Portfolio plan.

Crystelle, thanks we are doing the same thing pulling the nested queries out but we have almost 75 teams that we have to individually create to get the same data we get from the nested query. I was told that these nested queries are called Jira tricks but they don't seem to work for portfolio.

Crystelle S Community Leader Dec 19, 2019

yes, the information we were given at the conference seemed to indicate that people are seeing strange, varied behavior and it was being investigated. the workaround suggested was what you and I are doing... that was in April this year (2019)

Suggest an answer

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

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

260 views 0 6
Join discussion

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