Forums

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

Exclude weekends in JQL Query

Madhu Mullangi
March 12, 2019

I want to find out the tickets which are not updated for last 3 days[ Excluding Weekends ].

Is it possible using Jira JQL filters?

Thanks in Advance.

2 answers

1 accepted

2 votes
Answer accepted
Ollie Guan
Community Champion
February 28, 2014

I think Agile Board rule is created with the filter, rather than with the project

Although the data query device detected belongs to a project, but the data filter, find out the condition of two queries data without any commonality, so not visible to each other

josuetello
May 19, 2017

Ollie, i am not sure i understand your answer. Are you saying that the sprint is created and associated to the filter in the board it was created in? and not with the project? 

0 votes
Christian Czaia _Decadis AG_
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 Champions.
February 10, 2014

Which version of JIRA Agile are you using? Planned sprints don't show on other boards if you're using an old version of Greenhopper. Other than that, the JQL of your first query is buggy. Should be

project = XYZ AND issuetype = Bug ORDER BY Rang ASC

Cheers

Andre Lehmann
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 Champions.
February 10, 2014

Oh sry. Was a typo...
We are using Jira Agile 6.3.5

Suggest an answer

Log in or Sign up to answer