Excluding internal transitions from JQL search

[Joe Harmon]

I am stuck on an issue and I am hoping someone in the community can help me.  I have a query that lists issues when they move into a status of development.  This is a weekly list of what has been started and works fine.

project = PD AND status = Development AND "Development Start" >= -7d 

However we wanted to require some information when someone changed a date and so I put in an internal transition from development to development called "date changed".  This way I can do a transition screen.  That is all working okay as well.  However it caused an issue that now things are showing up in this list that shouldn't because these date changes are seeing something moving into development.  I want to exclude anything that was already in develop and just moved to development again.  I tried adding "AND status was not in Development" but that didn't work.  Is there a JQL query that can excluded this type of transition?  

Thoughts?

[Joe Harmon · Accepted solution]

This one worked for me.   and status was not Development BEFORE -7d

[Mikael Sandberg]

(Correcting myself)

You could try WAS NOT as part of your JQL like this:

project = PD AND status = Development AND "Development Start" >= -7d AND status WAS NOT Development

That should exclude issues that have already been in the Development status.

Another option is to have a post function on the circular transition that sets a custom field, you could then use that as part of your JQL like this:

project = PD AND status = Development AND "Development Start" >= -7d AND circular is EMPTY

[Joe Harmon]

Yeah that didn't work either.  That got rid of legitimate ones.  The circular isn't even an option for me.