I am in stuck with this quiz as follows:
Search the tickets which are resolved before 3months based on today.
For example, there are 3 tickets (A,B,C)
A: resolution date is 2018/11/01 (Over 3month)
B: resolution date is 2018/12/01 (Over 3 month)
C: resolution date is 2019/03/01 (under 1 month)
So the corrected JQL should search only A,B
Anyone help please?
Hello Nate - There is nothing available in native JIRA that will let you write a JQL query with month mentioned. Days and Weeks is how far it goes. So, if you are ok to translate this to about 12 weeks, then your query can be -
(project = ABC AND Resolved <= -12w)
And if you were to do this in days, I would run something like this -
(project = ABC AND resolved <= startOfDay(-90d))
Please review this document for Advanced Searching functionality
Hope this helps!
We’re excited to introduce external collaboration for Confluence, now available in early access. It is available to preview for Confluence Cloud Premium and Enterprise customers. (If you're not on ...
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