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; } } }

A complex filter

Doug Varn2

I've been banging my head on this, but I'm curious if someone can lend a hand.

I need a filter that basically:

1. finds issues assigned to particular people (done: "assignee in (membersOf(QA)) ORDER BY Rank ASC")

2. but of the issues that are closed, only show those that were closed within 2 weeks.

Accepted answers

Jobin Kuruvilla [Adaptavist]

Use this:

assignee in membersOf(QA) and status changed to Closed after -2w ORDER BY Rank ASC

All comments

Jobin Kuruvilla [Adaptavist]

Use this:

assignee in membersOf(QA) and status changed to Closed after -2w ORDER BY Rank ASC

Doug Varn2

i tried something like this, but the problem is i don't want to limit to closed items. it should retrieve items in any status BUT if they are closed, only the most recent (2 weeks). that's where i'm stuck.

real world-scenario: a filter for our kanban board (to do | in progress | done) set up so done (closed) items don't end up eternally filling up the column.

Jobin Kuruvilla [Adaptavist]

How about

(All your search terms except status) AND (status in ("All statuses you want") OR status changed to closed after -2w)

Doug Varn2

You are definitely a JQL guru!

One tweak was needed and that is to exclude Closed in the list of statuses I want.

(All your search terms except status) AND (status in ("All statuses you want EXCEPT Closed") OR status changed to closed after -2w)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql

filter