JQL query for status change from one status to another status is not working properly

[Mallikarjuna]

I tried with this query its not giving correct result

issuetype = xyz and (status changed from submitted to "xxx" OR status changed to "xxx") and status changed by xxx

[Andreas Lorz]

Hi @Mallikarjuna ,

when you say "is not working properly", you mean the query is not working at all and you get an error? Or it doesn't deliver a proper result wich you found out by looking on some sample issues?

Looking at this part of the query:

status changed from submitted to "xxx" OR status changed to "xxx"

Maybe you might expacting that you find all issues that were in status submitted and changed to either the "first xxx" or the "second xxx". But to achive this it has to be

status changed from submitted to "xxx" OR status changed from submitted to "yyy"

[Marc - Devoteam]

Hi @Mallikarjuna 

What should the result be.

This JQL will get all issues from type xyz, transferred from submitted to xxx and all issues from type xyz changed from any status to xyz 

Both related to the status changed by a user xxx

[Manon Soubies-Camy]

Hi @Mallikarjuna,

What result are you expecting with this query? If you want issues that were transitioned:

• From submitted to status xxx by user xxx
• or to status xxx by user xxx

Then you'd need to update your query to:

issuetype = xyz and (status changed from submitted to "xxx" by xxx OR status changed to "xxx" by xxx)

Hope this helps!

- Manon

[Valeriia_Havrylenko_SaaSJet]

Hі @Mallikarjuna  

Try this:

status changed from ("A","B","C") to ("X","Y","Z")

That workʼs for me :)