nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Payne

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)

All comments

Payne

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.