How to Exclude Weekends from JQL Query

[Christi Evans]

Question: How to exclude Saturday & Sunday from JQL filters. 

Backstory: We use a "Resolution Time" gadget on Jira dashboard that illustrates how many days it took to get bugs resolved, on average. 

It currently runs off this simple query: project = Puppies AND issuetype = Bug

We do not want Saturday & Sunday counted in the resolution time. We want Monday - Friday, business days only.

Additional Information:

It's Jira team-managed project

It's not a Jira Service Project (no SLA options afaict)

Want to exclude all weekends, not specific weekends. 

[Pedro Souza]

Hello,

Take a moment to check your logs for more clues about this behaviour:

• JIRA_Install/log/catalina.out
• JIRA_HOME/logs/atlassian-jira.log

[Pedro Souza]

• Try to connect using the default postgres user.
• Try changing from "127.0.0.1" to "localhost"

[Pedro Souza]

This KB will help:

https://confluence.atlassian.com/display/JIRAKB/JIRA+Crashes+Due+to+OutOfMemoryError+PermGen+Space+Error

[mostafa jamareh]

thank you Pedro Souza ,

catalina.out : Exception in thread "http-bio-8082-exec-15" java.lang.OutOfMemoryError: PermGen space

[Nic Brough -Adaptavist-]

What does the log file say? It will almost certainly have a lot more information, hopefully including the full error, than what you get on screen.

[mostafa jamareh]

thank you Nic Brough

there is no exception on jira logs on jira-home

[Nic Brough -Adaptavist-]

I very much doubt that - either the setup is still running, or it's failing with a set of errors in the logs.

Can you log into the database and check what Jira has created in there?

[mostafa jamareh]

catalina.out : Exception in thread "http-bio-8082-exec-15" java.lang.OutOfMemoryError: PermGen space

[mostafa jamareh]

there is no table on jira database

[Nic Brough -Adaptavist-]

Well, no, a memory error will stop it dead. Pedro is ahead of me here :-)