Forums

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

Is there a detailed guide on how to understand how to search using days in JQL?

Harry Bob
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.
April 22, 2020

Hello,

 

Is there any detailed guides or explanations on how to use JQL when it comes to days, weeks? 

 

like >= -7d or what => 7d

 

means and how to use it?

 

 

1 answer

0 votes
Kat Warner
Atlassian Partner
April 23, 2020

The Jira JQL Advanced Guide: How to Search Jira Issues Like a Pro covers a lot of ground about JQL overall.

Advanced search reference - JQL functions gets into the nitty gritty details.

For example:

endOfDay(inc)

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. endOfDay("+1") is the same as endOfDay("+1d"). If the plus/minus (+/-) sign is omitted, plus is assumed.

  • Find issues due by the end of today:  due < endOfDay()

  • Find issues due by the end of tomorrow: due < endOfDay("+1")

Harry Bob
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.
April 23, 2020

Thanks @Kat Warner 

Suggest an answer

Log in or Sign up to answer