JQL filter results status from X to Y

[Ritesh Jalan]

Hi,

I want to filter all the results based on following criteria

From (A,B,C) To (X,Y,Z)

A,B,C,X,Y,Z -- All of them are status.

What I need is if a ticket's status was changed from A or B or C to X or Y or Z then include the ticket otherwise ignore it.

I looked at the documentation but I could not find any solution. From and To always take only 1 status. Doesn't work like In.

Any help is appreciated.

Thanks,

-Ritesh

[Trudy Claspill · Accepted solution]

Hello @Ritesh Jalan 

Welcome to the Atlassian Community!

Try this:

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

That seems to work for me.

[Dave Rosenlund]

I was just typing more or less the same thing.  You could also play around with "status was" and "status is" if "status changed" isn't quite meeting your use case.

[Ritesh Jalan]

Could you please explain a bit about this. I was able to understand I can use WAS IN which accepts a list of status, does IS accept more than 1 status? I tried it does not accept a list of status.

[Ritesh Jalan]

Thanks @Trudy Claspill this worked for me.