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

Looking to create a specific filter query

AVARRIANNA ROXXZOR

Hey All,

I'm trying to clear a lot of my backlog, and I'm stuck on where to go for a specific filter to find items I need to close.

This is my current query;

project = project AND resolution = Unresolved AND updatedDate < "2018/04/01" AND status = Backlog ORDER BY updated ASC, priority ASC

I'd like to be able to find those cases that have also recently been updated my myself and another user in a certain time period.

I searched through https://confluence.atlassian.com/doc/search-139528.html and I don't think anything here applies to what I'm looking for.

Any assistance is appreciated!

Many thanks,

Tina. R

Accepted answers

Ed Gaile

you can use

AND status changed by <username>

so,

project = project AND resolution = Unresolved AND updatedDate < "2018/04/01" AND status = Backlog AND status changed by <username> ORDER BY updated ASC, priority ASC

All comments

Ed Gaile

Hey Tina -

You should be able to just add a "changed by <username>" condition to the query (if I am understanding you question correctly).

i.e.

project = project AND resolution = Unresolved AND updatedDate < "2018/04/01" AND status = Backlog AND changed by <username> ORDER BY updated ASC, priority ASC

-Ed

AVARRIANNA ROXXZOR

project = project AND resolution = Unresolved AND updatedDate < "2018/04/01" AND status = Backlog AND 'changed' = '<username>' ORDER BY updated ASC, priority ASC

It insisted on the quotes and I got a new error;

Field 'changed' does not exist or you do not have permission to view it.

I'm assuming this is where I need to implement a specific toolkit plugin?

https://marketplace.atlassian.com/apps/5142/toolkit-plugin-for-jira?hosting=server&tab=overview

Ed Gaile

use 'changed by' not 'changed ='

project = project AND resolution = Unresolved AND updatedDate < "2018/04/01" AND status = Backlog AND changed by <username> ORDER BY updated ASC, priority ASC

Ed Gaile

Sorry that's not right - one sec

Ed Gaile

you can use

AND status changed by <username>

so,

project = project AND resolution = Unresolved AND updatedDate < "2018/04/01" AND status = Backlog AND status changed by <username> ORDER BY updated ASC, priority ASC

AVARRIANNA ROXXZOR

No errors now! Many thanks

Welcome!

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

Quick Links

Find more posts tagged with

jira-core