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

Advanced JQL

Teza Jonnalagadda

Hello Team, Can one of you help on writing the advanced JQL for the below requirement, please?

In Project IT all the tickets that are not Resolved(tickets that are in Open and In-Progress) before 2021 plus ALL the tickets that are created in 2021?

Thanks.

Accepted answers

Jack Brickey

Try this...

project = IT and createddate >= startofyear() OR resolutiondate >= startofyear()

All comments

Jack Brickey

Try this...

project = IT and createddate >= startofyear() OR resolutiondate >= startofyear()

Teza Jonnalagadda

This is showing more data than needed, its pulling data for other projects as well.

Jack Brickey

Sorry left off some parentheses.

project = IT and (createddate >= startofyear() OR resolutiondate >= startofyear())

Teza Jonnalagadda

Thanks but this is still showing tickets that are created in 2018 and are in Closed state. Can you pls advise?

Here is my criteria, we only want to see the tickets that are created in 2021 and the ones that are open(not resolved) prior to 2021.

KAGITHALA BABU ANVESH_z1zl10

Hi @Teza Jonnalagadda ,

For "all the tickets created in 2021 plus anything that is open and created in 2020?"

project = "IT" AND (createdDate >= startofyear('-1') and statuscategory != done) ORDER BY created ASC, updated DESC

Please check this.

Thanks,

Anvesh

Teza Jonnalagadda

@KAGITHALA BABU ANVESHThis is pulling tickets that are Completed as well(Resolution is Fixed). can you help?

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server

jql