nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter with report column of user who changed the status

Dave Bair

I am looking for some help on a Jira query / filter. We are about to do a significant cleaning of the backlog and I am trying to create a report that shows all the tickets we rejected. That part is easy, what I am stuck on is how to get the "rejected by" person in the report.

Filter JQL that is returning the right list of tickets

project = FORM AND status changed TO Rejected after 2024-11-05

Now I want a column in the report to tell me who Rejected that ticket.

Accepted answers

Petru Simion [Simitech Ltd.]

You can use CIFJ - Issue History For Jira

https://marketplace.atlassian.com/apps/1235591/cifj-issue-history-dashboard?

hosting=cloud&tab=overview

The app is recently released by our company.

You can search and filter issue history using the field Updated By.

Once you obtained your desired result you can either use the list of issues or export to CSV.

Screenshot from 2024-11-06 20-59-30.png

All comments

Trudy P Claspill

Hello @Dave Bair

Welcome to the Atlassian community.

That will not be possible if you have only the native Jira JQL functionality available. Native JQL and results display is very limited in what it can filter against and display related to issue history.

There are at least a couple of alternatives you could consider:

1. Look for a third party app that would help you get the data you want.

2. Develop a custom extraction using the Jira REST API

If this is something that you think will be an ongoing need and you don't want to use a third party app, you could set up a custom field and an Automation Rule (or add to the workflow) to set the custom field to the user executing the Reject transition.

Petru Simion [Simitech Ltd.]

You can use CIFJ - Issue History For Jira

https://marketplace.atlassian.com/apps/1235591/cifj-issue-history-dashboard?

hosting=cloud&tab=overview

The app is recently released by our company.

You can search and filter issue history using the field Updated By.

Once you obtained your desired result you can either use the list of issues or export to CSV.

Screenshot from 2024-11-06 20-59-30.png

Yuliia_Borivets__SaaSJet_

Hi @Dave Bair

I think the method with custom field + automation might work for you.

If you are open to using apps, you can check out Issue History for Jira developed by my team. It provides a separate column and filter for "Updated by" person.

status updated by in jira.png

Here, I have a similar post: How many Jira issues were rejected after testing?

Dave Bair

Thank you for the insight, and the tool. We have installed it in our app on a trial basis and I am getting good results.

I am having a bit of a hard time getting the filters to work just right though.

I can get the ones in Rejected that had a change in the last week - that is perfect!

However, when I add the criteria to only report when a status changed, I am getting no results. Can you help me understand what I am doing wrong?

Screenshot 2024-11-08 at 11.35.00 AM.png

Screenshot 2024-11-08 at 11.33.02 AM.png

Petru Simion [Simitech Ltd.]

Hi @Dave Bair

I am looking into it. Will do a few tests and let you know.

Glad you like the rest of the functionality.

Regards,

Petru

Petru Simion [Simitech Ltd.]

Hi @Dave Bair

I tested and the search works correctly. Please see attached img.

What I see is that you were able to add multiple statuses with label Rejected in your search field. That shouold not be possible, as Jira does not allow adding multiple statuses with the same label. The Status drop down field allows multiple values, but once you added a value you can not add it again. When you click the drop down, you will see all statuses that have not yet been added to the field. At the beginning, when you have no values selected, you see all the statuses ordered alphabetically. Do you see more than one value for Rejected? If you do try clearing your cash and try again.
If you want to search for the user that moved an issue into status Rejected, then all you need to search for is the value Rejected in the field Value To. If you select also the Rejected value in the Status field, you are searching for a field for which the status was changed to Rejected that is still in the Rejected status. Which can give you less records. Not sure about your use case but an issue can be moved into Rejected status and later moved into another status. You might want to filter for: Field Updated - Status and Updated to - Rejected.

The tool works like this.

You need to select a Project. Otherwise the search result can be unpredictably large.

If you just select the Project and hit Search, history for all issues in that project will get displayed in the table below.

If you select any values for the other fields, the result will be filtered to only match values accordingly.

If you populate more fields, the result of the search is an AND.

For example: Field Updated = Status and Value To = Rejected will return all issues where the field that was updated is the Status and the value that the user updated the status to is Rejected.

Hope this helps.

What I am interested in is how those multiple values of Rejected could be added to the Status field. Please test again after clearing your cache and let me know.

Thanks.

Regards,

Petru Screenshot from 2024-11-08 17-15-37.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud