Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,601
Community Members
 
Community Events
176
Community Groups

membersof command not returning expected results

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

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

Cheers

2 answers

1 accepted

1 vote
Answer accepted

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.

@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!

Like Antoine Berry likes this
0 votes
iryna_k_SaaSJet_ Marketplace Partner Dec 15, 2022

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS

Atlassian Community Events