membersof command not returning expected results

[Phil Hayes]

I've been playing around with some JQL to give me information about users who are not part of a group who are updating issue statuses to done

The JQL I've been using is:

Status changed to "DONE" AND NOT status changed BY (membersof("My Team")) AND issuetype in ("Story", "Task")

However, for the purpose of testing I have a separate account that isn't part of the "My Team" group and I'm not seeing the stories or tasks I move using this account appear in my results

I think I've got everything right within this, but any help would be appreciated!

Cheers

[Antoine Berry · Accepted solution]

Hello @Phil Hayes ,

Not linked to your problem, but if I am not mistaken your filter retrieves : 

• Issues moved to "Done" status
• Issues that had a status (whichever one, not only to Done) changed by a user who does not belong to "My Team"

So you would need this logic :

Status changed to "Done" not by membersof("My Team")

But I do not think this is feasible. Instead you can create a filter (let us call it "Filter 1") : 

Status changed to "Done" by membersof("My Team") 

And then use this filter :

Status changed to "Done" and issuetype in ("Story", "Task") and filter != "Filter 1"

 But then again I do not think that explains why your stories and tasks do not appear.

[Phil Hayes]

@Antoine Berry - I hadn't though of splitting it like that, I was too focused on completing it all in one query

It works and returns the expected results too

Thanks for your support on this!

[Iryna Komarnitska_SaaSJet_]

Hello @Phil Hayes ,

Try Text to JQL   gadget, that my team recently released. The gadget is free.

This AI/ML-based solution not just converts entered by the user natural-language text into a corresponding JQL query. Gadget is customizable and accepts requests of different complexity.

I hope it will be useful to you.