Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

jql to view issues created from last week tuesday 8 am to this week tuesday 8 am

arun kumar rathina kumar August 26, 2020

jql to view issues created from last week tuesday 8 am to this week tuesday 8 am

2 answers

0 votes
Iago Docando
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 28, 2020

Hi @arun kumar rathina kumar. I don't think that's possible using vanilla JQL.

Even more important, the concept is flawed since I don't think you can choose that your weeks start on tuesdays... this means the search "this week's tuesdays" run on mondays won't ever return anything since you can not see the future.

The solution by @Bryan McMillan of course returns what you're looking for when you manually set the dates but I understand you want an expression valid for every tuesday and not a static date. And that, my friend... I think that's well beyond JQL capabilities. You could expect that something like "created > startOfWeek(+32h)" worked just fine but that's not the case. Instead, startOfWeek() means "start of THIS week", startOfWeek(-1) means "start of LAST week", and so on...

You could maybe try some custom field that allows you to code (maybe take a look at Power Custom Fields or something similar) and in that custom field you could write code that returns a "1" if your condition is satisfied, "0" otherwise. Then you just need a standard filter with the very mundane JQL "customField_xxxxx = 1".

There are also some apps/plugins that extend the capabilities of regular JQL, maybe some of them can give you that functionality but I honestly don't know. You'll have to do the research and check those but it is a plausible option.

I hope it helps :)

0 votes
Bryan McMillan
Contributor
August 27, 2020

@arun kumar rathina kumar to answer your excellent question you have to actually specify the dates and times as follows:

createdDate > "2020-08-18 08:00" AND createdDate < "2020-08-25 08:00"

 

This JQL will provide you the results of all issues across all projects created between last week Tuesday 8 am to this week Tuesday 8 am.

Sincerely,

 

Bryan McMillan

Solutions Architect

Cprime, Inc.

Suggest an answer

Log in or Sign up to answer