Help with JQL: assignee changed FROM NOT IN (a,b,c) TO (a,b,c)

[Denis Poisson]

I'm trying to find out how to search tickets that reached our team this month from outside (not just passed around our team)

The pseudo-query above results in an error, since "FROM" requires a specified previous assignee or group of assignees. Our tickets can come from multiple sources, I don't want to specify "the rest of the internet" :D just "Not our team".

[Gezim Shehu [Communardo] · Accepted solution]

Do you have groups for teams?

Maybe you could use memberOf within the FROM.

If urgent just use SQL towards the DB

[Denis Poisson]

Thank you very much Gezim, 

Unfortunately, while

assignee changed FROM membersOf("myGroup") TO membersOf("myGroup)

 works fine,

assignee changed FROM !membersOf("myGroup") TO membersOf("myGroup")

 throws an error. Same if I add the "!" in front of !"myGoup"

SQL may be a way ahead. Thanks for the suggestion.