Advanced Search using JQL: 5 days old tickets in waiting for customer

[Soporte Tecnalis]

The JQL is driving me crazy! I am using automation for JIRA and I am actually using it to replace the default automation in JIRA, the one that was telling you: send a message for tickets that are in status waiting for customer for the last 5 days. Seemingly, I am replacing the rule: solve the ticket after 10 days the ticket is in waiting for customer status.

I need to run a JQL in automation for JIRA but always unsuccessful: either there is nothing found or the query finds tickets that do not comply with the rule itself. I've tried:

status = "Waiting for customer" AND updated <-6d AND updated >-5d 

status = "Waiting for customer" AND updatedDate <-5d AND updatedDate >-6d

status = "Waiting for customer" AND updated >-5d AND updated <-6d

and a lot more....do you have any tips for me please?

[Deleted user · Accepted solution]

Hey there Soporte,

You'll want to use the "status changed to" keyword: 

issuetype = Support AND status = "Waiting for customer" AND NOT status changed to "Waiting for customer" after -5d ORDER BY updated DESC

Hope that works!

Cheers,

Mark C

[Soporte Tecnalis]

hank you very much! It seems to work!

[Soporte Tecnalis]

I am also trying little tweaks on this formula but it is not working

(status = 'Waiting for customer' AFTER 10d) AND (status = 'Waiting for customer' BEFORE 11d)