It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Count Working Days Only

Hi - I would like to filter issues which have been in a certain status for more than 3 days. However, I am only interested in working days. I understand that "-3d" would not work. Is there a way?

2 answers

2 votes
Rodrigo Rosa Atlassian Team Aug 25, 2015

Hello Mariola,

this previous answer might help you achieving what you need. 

Also, we have a feature request for it: https://jira.atlassian.com/browse/JRA-22506

 

We have a Days Elapsed Plugin for JIRA that might be able to help.

The recipe:

  1. Add a traffic light custom field
  2. Setup the calendars to indicate the working days
  3. Configure the thresholds such that 3 is red
  4. Fire a post function to trigger on the traffic light custom field upon status change
  5. You can query all the issues that exceeded 3 days by searching for red traffic light

Note: When the issue is resolved or closed, you need a post function to trigger off. Otherwise it will keep on counting.

 

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you