Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Filter action by user

Peter Fahlstrom
Contributor
October 5, 2021

Hi all, hope i can find a solution to:

I want to create a filter where the project = X where the issues are set to Done a certain date by the user Y…how do I proceed? Is this possible?

 

Thanks!

3 answers

2 accepted

1 vote
Answer accepted
Alex Koxaras -Relational-
Community Champion
October 5, 2021

Hi @Peter Fahlstrom 

Try something like this:

status CHANGED TO "Done" DURING(startOfMonth(-1), now()) BY username

Of course make the necessary changes to the above JQL to fit your needs. Please read also this documentation

Peter Fahlstrom
Contributor
October 5, 2021

Thanks Alex, for some strange reason the JQL does not recognize the username despite the fact it is correct...

Alex Koxaras -Relational-
Community Champion
October 5, 2021

What message do you get?

Peter Fahlstrom
Contributor
October 5, 2021

The user 'X' does not exist and cannot be used in the 'by' predicate.

Alex Koxaras -Relational-
Community Champion
October 5, 2021

Pete, I confirm that BY and username doesn't work. However, it works by placing the user id. To find the user id, go back to basic search, and select as e.g. assignee that user. Once you've done this, go back to jql. Now you will get something like

assignee in (5f9fb7c1c2e5390077abf628)

Copy this id to the above statement. Final JQL should look like this:

status CHANGED TO "Done" DURING(startOfMonth(-1), now()) BY 5f9fb7c1c2e5390077abf628
Peter Fahlstrom
Contributor
October 5, 2021

This worked well Alex, thanks!

Alex Koxaras -Relational-
Community Champion
October 5, 2021

Nice! :D

1 vote
Answer accepted
Mohamed Benziane
Community Champion
October 5, 2021

Hi,

You can try this:

status changed TO "Done" by USERNAME DURING (YOURDATE1, YOURDATE2)

 

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-939938733.html

0 votes
Peter Fahlstrom
Contributor
October 5, 2021

Thanks for your input Mohamed, i like the idea of a data range in your query, will be useful!

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, mindful member, mindful member badge, atlassian community, community kudos, community giveaway, atlassian swag, community values, empathy and kindness, badge challenge, atlassian learning, community engagement, swag giveaway

Earn a Badge, Win a Prize 🎁

Earning the Mindful Member badge proves you know how to lead with kindness, plus it enters you into a giveaway for exclusive Atlassian swag. Take the quiz, grab the badge, and comment on our announcement article to spread the good vibes!

Start here
AUG Leaders

Atlassian Community Events