Is there a way to create a filter or a report for several specif users?

I would like to be able to pull a report by sleecting specific users and from what I see, at least in queries, I can pull by"Current user" which would be me, or another user but all in all, I can't add more than one user. I would like to be able to pull information, no matter if is it an issue, a sub-task, enhacemnet, New feature, but the important piece is to be able to report on several users activities in JIRA.

Thanks so much!
Carolina

5 answers

1 accepted

Accepted Answer
2 votes

You should be able to simply say "user in (alice, bob, charlie)".

Hi Nic, can you send me a screen shot of where in JIRA you are saying I should be able to add several users to pull any/all their activities? (issues, sub-tasks, etc)

It this a report or at the Filter issue search?

Thx again!

Carolina

Go into an issue search, click "advanced" and type it into the advanced JQL query. Note that I've just said "user" in my query above - you haven't defined what you're using to class an issue as "theirs". Assignee or reporter are the most likely options of course.

I am only able to add cf[12530] =Name user

I need to be able to add more users....I added AND but althought the Auto compete option let's me add another user:

cf[12530] =SG0894 AND cf[12530] =SG0203 AND cf[12530] =SG0896

when I run te query I get: No matching issues found.

Ah, that's a logic mistake. For that query to work, the custom field would have to be a multi-user-picker and have all three users selected.

I think you want OR, not AND. Just try replacing the two AND with OR in there and see what it does.

Perfect!!! that worked!!! Do you know if I can add the "Status"?

I need to be ablel to report on certain users issues, and differenciate between, Open, Closed, etc...to determine for example, for the last month....my Team created x amount of issues where x are Open, x are closed an so on.

Thanks so much for your help!! Amazing!!!!!!

Ok, first, I find it's easier to separate out the query from the results output in your mind.

The query is a description of the list of issues you want to get some reports on. When you run it, Jira just writes a list of all the issues that match the question. Nothing more - the list has nothing to say about the data you're going to report on, it really is *just* a list of issues.

The output is a function that takes the list of results, reads out whatever information it's been told to about each issue, and then does something to give it to the user.

So, the issue navigator is a an output function that pulls out and displays a list of fields for each issue, with the fields being chosen by the user. The dashboard "filter statistics" gadget does some simple arithmetic on the list, counting the incidences of selected data values for each issue on the list. The resolution time report looks back at the status of issues and works out some times to give to the user. And so-on.

I've rattled that off because I'm not quite sure of your new question's intent.

Yes, you can add "status" to the query. You can say stuff like "And status = open". Or even "and status WAS open" although that's a bit more advanced. But that;s just the query part. I think you want to be looking at the output part now. Taking the list of issues and pushing it through something that will tell you the information you need.

So, first, phrase the question: I think you probably just want to start with "<users> in (a,b,c) and created > -31d" to get all the issues created in the last month (there are functions for pulling start/end of month type data too)

Then look at the output. I'd think about a "filter statistics" gadget on your dashboard. Use the filter and then choose "status" as the field to group by. I'd also have a look at the "created vs resolved chart" you can get as a gadget, as I think that could be really handy for you too

WOW, you have given me a LOT of info to move forward. I have something to start looking at me Report "to be' now. I will probably be back with some more questions. So far, I can't thank you enough. You've been SUCH a great help!!! Thank YOU Thank YOU Thank YOU!!!!!

Carolina

I am back, I was not able to tied up the great information you gave me.

Maybe if I go a step back and say that what I need is to be able to pull a monthly report that will give me a list of any type of Issues, Sub-tasks, etc that a specific list of users has created or has assigned to it's name.

Does this make sense? It might not be as simple to get this in JIRA :)

Thanks,
Carolina

I think that's already been answered. Search for "reporter in (user1, user2, user 3) or assignee in (user1, user2, user 3)", and push the results through a gadget that displays the info you need from the issues.

Hi Nic, I was finally able to create the query I needed.

project = SSS AND component = SECURITY AND reporter = user A OR reporter = user B OR reporter = user C OR assignee = user A OR assignee = user B OR assignee = user C ORDER BY created DESC

Just wanted to share with you since you help me a LOT!

Thanks again!!!

Carolina

Hello Carolina,

What version of Jira are you using?

Hi Christopher, I am using JIRA v5 1.8

Thanks!

Thanks Nic, your help was Perfect!!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 25, 2018 in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

461 views 7 5
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you