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

combining diferent jql-results in 1 table

Hello,
I want to see the amount of issues :
1: created in the last 7 days,
2: or closed in the last 7 days (issue can be listed twice if closed before 7 days),
1+2:
project = HELP AND (created > -1w OR status = "(ITRP) CLOSED" AND status changed to "(ITRP) CLOSED" during (-7d, now())
3: or all issues that are open more tehn 7 days (backlog).
OR project = HELP AND Status = "(ITRP) Open") AND updated < -1w

I think this isn't possible with 1 query: query 1+2 and 3 = 2 query's.

if right, can jira present the result in 1 list/table e.g. with the plugin for google sheeds or (ms excel in the future)?
or should I execute the 2 query's separately and paste them together manually?

In excel, I could then count the amount of issues by team and different statusses with a pivot table.


Any hints are welcome
Kind regards
William Windels

1 answer

1 accepted

0 votes
Answer accepted
Payne Community Leader Jun 26, 2019

You may find it useful to save your subqueries as individual filters and then combine filters in your JQL, such as

filter = filter1 and (filter = filter2 or filter = filter3)

New to this, folks. Trying this solution out, but do I enter the filter # or filter name? For example, if i have individual filters of dogs titled: terriers, shepherds, collies, toy - and want to combine them into a single report, do i use the report names:

all dogs = terriers and (all dogs = shepherds or all dogs = collies or all dogs = toy)?

Payne Community Leader Sep 12, 2019

Hi Julie - Use names. In Advanced mode, if you type filter = you should get a dropdown of filter names to choose from to help you.

 

jira.jpg

Suggest an answer

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

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

365 views 1 3
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