Advanced Searching with JQL

[Manu Mishra]

Hi,

I have a query wherein I want to search the issues have not been updated in -48h, so created the below JQL, which is working fine.

Status != Done AND assignee in (XXX.XXX.XXX.XXX.XXX) AND updated < -48h ORDER BY updated asc

However, the above JQL includes the Weekend's as well which is a trouble for us because we dont work on weekends. So i would like to create a JQL for the issues have not been updated in -48h which excludes the Saturday & Sunday...

[Yogesh Mude]

HI @Manu Mishra

I think this can not be done currently, you can find already created feature requests as below...

https://jira.atlassian.com/browse/JRASERVER-27539

https://jira.atlassian.com/browse/JRASERVER-22506

Or else you need to your own custom JQL function add-on.

https://community.atlassian.com/t5/Answers-Developer-Questions/Exclude-weekend-in-days-query/qaq-p/485006 

Please vote on this requests...

[Manu Mishra]

@Yogesh Mude The link you mentioned 

https://community.atlassian.com/t5/Answers-Developer-Questions/Exclude-weekend-in-days-query/qaq-p/485006  is seems to be invalid. 

is there any workaround right now?

[Yogesh Mude]

Hi @Manu Mishra

Here is the same question has been created by one of the User, please have a look at it..

I don't this so it will be possible, you need to write your own custom JQL function add-on.

[Manu Mishra]

Thanks @Yogesh Mude