how to Exclude weekends in JQL Query for last 7 working days

Question

Hi Team,

Trying to filter the issue which is 7 working days

example:-  project=ind and issuetype= qat and status= in progress and status changed before -6d

Can you please suggest to me how to achieve the filter by excluding weekends sat, sun.

Thank you,

Naveen.

sreenivasaraju P · Answer

Hi @naveen arroju ,

As per my knowledge, out of the box, jira doesn't have this feature.

You can try with startOfWeek() and endOfWeek() options

Please refer below link for the similar question.

https://community.atlassian.com/t5/Jira-Core-Server-questions/Exclude-weekends-in-JQL-Query/qaq-p/1030290

https://community.atlassian.com/t5/Jira-Core-Server-questions/Exclude-weekends-in-jql-query/qaq-p/245398