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

Need help with these JQL queries (issues done yesterday & day before yesterday)

Levan Khutsishvili

Hello,

Can anyone help me to write JQL's

I need to search tasks which where done yesterday and also tasks which where done day before yesterday
I know that they can be searched from issues and filters section but i need them in quick filters

thanks in advance

Accepted answers

Grigory Salnikov_0hffsd

Hi @Levan Khutsishvili and welcome to our Community!

I think you need something like this:

project = <project name> AND resolution = Done AND resolution changed AFTER startOfDay(-1) BEFORE endOfDay(-1)

for issues done yesterday and

project = <project name> AND resolution = Done AND resolution changed AFTER startOfDay(-2) BEFORE endOfDay(-2)

for issues done the day before yesterday.

Hope this helps.

All comments

Grigory Salnikov_0hffsd

Hi @Levan Khutsishvili and welcome to our Community!

I think you need something like this:

project = <project name> AND resolution = Done AND resolution changed AFTER startOfDay(-1) BEFORE endOfDay(-1)

for issues done yesterday and

project = <project name> AND resolution = Done AND resolution changed AFTER startOfDay(-2) BEFORE endOfDay(-2)

for issues done the day before yesterday.

Hope this helps.

Levan Khutsishvili

Hello Grigory,

Thanks for quick feedback. I'll try them out and let you know.

Levan Khutsishvili

It worked! thanks a lot Grigory

Grigory Salnikov_0hffsd

You're welcome, Levan

Should you encounter any other difficulties don't hesitate to come back here.

Have a nice day!

P.S. You may also want to mark the answer as "Accepted" so that other people with the same or similar question would find it easily. To do it just click on the "Accept answer" green button.

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