The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

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

JQL in different date/time context

Thomas Berg
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 23, 2022

Is it possible (maybe using plugins) to make a JQL in context an earlier DateTime, e.g., one week ago?

 

Meaning that the results returned on my query are the same results as if I ran the same query one week ago?

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

1 vote
Ed Gaile _Atlanta_ GA_
Community Champion
May 23, 2022

Not sure I am totally following what you are trying to do, but you could try using some of the existing JQL functions like:

startOfWeek(-1) would be last week

startOfDay(-7) would be 7 days ago

Thomas Berg
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 26, 2022

Sorry for the bad explanation.

At the end of week 1 let's say I do a query of all cards with status open. Let's say it returns 10 cards

Now, at end of week 2, I want to do a query of all cards with status open at the end of week 1. Which should also return 10 cards. - No matter how many cards were opened/closed/reopened during week 2.

The same thing at the end of week 3, I want to do a query of all cards with status open at the end of week 1, which again should also return 10 cards.