JQL question regarding STATUS CHANGED TO

[Hoc]

Hello, 

I am using a JQL below which works for the 'Done' status.

Project = "Digital Marketing Group" AND status = Done AND Status CHANGED to Done AFTER -14d 

I have another project but has the Completed status instead of Done. When I update it to use 'Completed' it doesn't work. I get no results.

Project = "Fulfillment" AND status = Completed AND Status CHANGED to Completed AFTER -14d 

Does the query only work on certain statuses?

Thanks

[carlosughini]

Hello there,

Hope you are having a good week!

There are some possibilities that might be happening here.

The first of them is that actually you do not have any issues that transitioned to the "Completed" status in the last 14 days. Could you please double check and confirm that you actually have tickets that are in the "Completed" status and changed in the last 14 days?

Second thing that I would check is to access the Statuses page and confirm that the status is actually only "Completed" and then trying to query it through JQL by using double quotes (").

Could you please perform the steps above and let me know how it goes?

Kind regards,

Carlos

[Hoc]

Hey @carlosughini 

I did check and there is issues completed last 2 weeks. I had to use a different query to show the tickets. The resolved date doesnt show any date so I had to use updated field instead.

I did notice that its a SERVICE PROJECT rather than a SOFTARE PROJECT so not sure if the JQL query works depending on the Atlassian product.