Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can someone tell me an easier way to write this JQL filter?

project = TUBI AND issuetype = "Work Request" AND "Closed Date" <= "2021/6/30" AND "Closed Date" >= "2021/6/1" AND "Implementation Date" < "2021/6/1" AND "Line of Business:" = "Wholesale Banking" OR "Closed Date" <= "2021/5/31" AND "Closed Date" >= "2021/5/1" AND "Implementation Date" < "2021/5/1" AND "Line of Business:" = "Wholesale Banking" OR "Closed Date" <= "2021/4/30" AND "Closed Date" >= "2021/4/1" AND "Implementation Date" < "2021/4/1" AND "Line of Business:" = "Wholesale Banking" OR "Closed Date" <= "2021/3/31" AND "Closed Date" >= "2021/3/1" AND "Implementation Date" < "2021/3/1" AND "Line of Business:" = "Wholesale Banking" OR "Closed Date" <= "2021/2/28" AND "Closed Date" >= "2021/2/1" AND "Implementation Date" < "2021/2/1" AND "Line of Business:" = "Wholesale Banking" OR "Closed Date" <= "2021/1/31" AND "Closed Date" >= "2021/1/1" AND "Implementation Date" < "2021/1/1" AND "Line of Business:" = "Wholesale Banking"

2 answers

3 votes
John Funk Community Leader Jun 04, 2021

Hey Richard - Wow, that is quite the query. Can you just describe in words what you are wanting to see?

Jack Community Leader Jun 04, 2021

Indeed that query seems impossible to maintain 

Like # people like this
2 votes
JimmyVanAU Community Leader Jun 04, 2021

Hi Richard,

I think the simplest it can be made is to use some parentheses:

project = TUBI AND type = "Work Request" AND "Line of Business:" = "Wholesale Banking" 
AND
( "Closed Date" <= "2021/6/30" AND "Closed Date" >= "2021/6/1" AND "Implementation Date" < "2021/6/1"
OR "Closed Date" <= "2021/5/31" AND "Closed Date" >= "2021/5/1" AND "Implementation Date" < "2021/5/1"
OR "Closed Date" <= "2021/4/30" AND "Closed Date" >= "2021/4/1" AND "Implementation Date" < "2021/4/1"
OR "Closed Date" <= "2021/3/31" AND "Closed Date" >= "2021/3/1" AND "Implementation Date" < "2021/3/1"
OR "Closed Date" <= "2021/2/28" AND "Closed Date" >= "2021/2/1" AND "Implementation Date" < "2021/2/1"
OR "Closed Date" <= "2021/1/31" AND "Closed Date" >= "2021/1/1" AND "Implementation Date" < "2021/1/1")

It looks like you're trying to see which issues were closed within one month of implementation.

One suggestion is to use Automation to identify issues which meet this criteria, e.g. with a label, or a custom field "Closed within one month of implementation". Not particularly a huge fan of custom fields with one purpose, but however, you tackle it is up to you.

You can use automation with a scheduled trigger (make it 5 minutes from  now), for all issues which meet this JQL criteria, then apply the change (new lable/custom field + value).

Your dashboard or filter will then be much neater.

 

If Closed Date is the same as resolution date (resolved field), then you could simplify the existing JQL using something like:

status WAS "Closed" DURING ("2021/2/1","2021/2/28") AND "Implementation Date" < "2021/1/1"

but I would still suggest you look into identifying the issue in another way. This will simplify your searches and scale for future months.

Cheers, Jimmy

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

☕️ Monday coffee with Jexo: Weekly Atlassian news roundup | 21st June 2021

Hi community 👋, as every Monday we're bringing you a quick update on what happened in the Atlassian ecosystem last week. There were a few interesting events like for example the announcement of th...

51 views 0 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you