I need help writing a JQL query that shows if an issue has not been changed from "In Analysis"

[Akshay Patel]

Hello!

I am having trouble creating a JQL query that searches for all the issues in a project that has not changed statuses from "In Analysis" ever. 

project = "Enterprise Collaboration Platform" AND status = In Analysis AND NOT status changed 

[Petter Gonçalves]

Hello Akshay,

Welcome to Atlassian community!

Can you please provide us with how your workflow is configured and how you have configured the post function? 

I believe you could use different transitions to move the issues in the workflow:

- One to move from In development to In analysis

- One to move from any other statuses to In analysis

Then, you can configure the notification post function only in the transition that moves from any other statuses to In analysis.

Also,  you can use the parameter WAS to return issues in the JQL query that has not passed by the In Development status before:

status was not "In Development" and status = "In analysis"

 Let me know if one of the options above works for you.

[Akshay Patel]

Hello!

The idea behind the post function is to send an email when the issue is "In Analysis". This works as intended. However, I ran into the problem when the issue has moved to another status, let say "In Development" but then is moved back into "In Analysis". This will send the email twice (because it was originally "In Analysis" then moved to "In Development" then back into "In Analysis"). I just want the email to be sent once, regardless is the status of the issue changed.

I really appreciate the help!!