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!
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 =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 =SG0894 AND cf =SG0203 AND cf =SG0896
when I run te query I get: No matching issues found.
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!!!!!
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 :)
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!
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
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!
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