Find all tickets without a specific TRANSITION

Question

Is there a way to create a report, in JIRA Service Desk, to find all tickets without a specific "Transitions"? Ex : All tickets without External Pending in "TRANSITIONS" history.

michel_provencal · Answer

Thanks both of you.

That solved my problem!!!!!!!!!

It is my first post here, and you solve my question in less than 5 minutes.

You are fantastic.

John Funk · Answer

Hi Michael,

There is also this:

project = ABC and status was not in ("Develop Underway") during (startOfMonth(-1), endOfMonth(-1))

That shows you all issues that were never in Develop Underway status during last month. You can change around the dates if you like or remove the during completely.

Alexis Robert · Answer

Hi @michel_provencal ,

you can use the "changed from" operator in JQL to do this :

NOT (status changed FROM BACKLOG) OR NOT (status changed TO BACKLOG)

You can then save this search as a filter and use it in a Filter Result gadget for example.

Let me know if this helps,

--Alexis