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?

 

unknown

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