combining diferent jql-results in 1 table

[William Windels]

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

[Payne · Accepted solution]

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)

[Julie Durrant]

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]

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.