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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Looking for JQL filter to see a user's activity on issues

On a user's profile I can see his activity in both JIRA and Confluence. What I need is the list of issues the user was active in (added a comment, a commit, changed the status, updated any of the fields, etc.)

I expected the following to work but I this does not work obviously because updated is a DateTime value:

project = XXX AND updated by user

Any solutions to see user's activity on issues?

12 answers

Is this what you're looking for?

issue in issueHistory() ORDER BY updated DESC

That is awesome!  

 

issue in issueHistory() AND updated > startOfDay() ORDER BY updated DESC

 

Seems to show what I worked on today pretty well.  And, of course, things that were worked on after I touched them, which is also of interest...

Probably not what you want, see doc:

issueHistory()

Find issues that you have recently viewed, i.e. issues that are in the 'Recent Issues' section of the 'Issues' drop-down menu.

https://confluence.atlassian.com/jiracorecloud/advanced-searching-functions-reference-765593719.html#Advancedsearching-functionsreference-issueHistoryissueHistory()

Hey Vasyl,

There is an improvement request open for the last 10 years. You might want to vote up on it.

https://jira.atlassian.com/browse/JRA-1973

Cheers

Bhushan

That's quite funny. :) Any time I need to do something in JIRA 50% chance that "there is a request opened for 10 years". :)

Though, I need a workaround for OnDemand people.

Like # people like this

I would say it's more like a 90% chance.

Like # people like this

And there is a 100% chance that our plugin answers your needs without waiting 1 more second wink

  https://marketplace.atlassian.com/plugins/com.ugubi.streams.filtersactivitystream/server/overview 

 

You can test it for free up to 6 months.

 

Ugubi Team

More like a 0% chance. Considering the question is tagged with "jira-cloud", your plugin won't solve anything for the OP.

According to https://jira.atlassian.com/browse/JRASERVER-1973, this is now a released feature in 8.0.0. E.g.

issue in updatedBy('Homer Simpson')

Like William Rapha likes this

there's a 100% chance that there's a plugin that you'll have to buy to do every rinky dink thing that the product should already support.

This product is designed to nickle and dime you to death.

Like System Administration likes this

well plugins are great for administrators of the platform but if I'm a user I can't just install a plugin... it really is surprising how so many medium to big size organizations pay so much for this kind of software with such basic flaws and lack of support

LOL did Jira "like" the comment by @jennifer smith 

This is embarrassing.

I can't just click on user's name or profile or whatsoever and see user's last activity.
There are community posts about it for almost 10 years and still no solution.
People spend hours trying to configure the activity stream username filter without any luck.

Could you just fix it, Atlassian!

I completely agree with Vahur! Atlassian, are you planning to add this feature?

You have to add a Jira plugin to get the "Participants" field. but my query looks like this:

Participants = currentUser() ORDER BY updatedDate DESC

Which plugin?

A new JQL function that support this was added a while ago. See my answer here.

Hello.

 

We are happy to announce that our plugin Custom Filters Activity Stream for Jira is now available for Cloud customers. 

 

Please follow this link to view the plugin : https://marketplace.atlassian.com/apps/1213902/custom-filters-activity-stream-for-jira?hosting=cloud&tab=overview

 

Feel free to contact us in case of any questions or support.

 

Best regards, 

Sébastien De Luca

Ugubi Team

I want to filter by user name in AND clauses.  If this requires an add-on, my mind is boggled.

Is there a cloud solution for this? 

 

Thanks

Hi,

Our Custom Filters Activity Stream plugin adds the possibility to filter the activity stream based on a JQL filter.

Best regards,
Ugubi Team

Your only solution I see for OnDemand is to use the REST API and pull the information over and format yourself. To keep things simple, you can format the data into a csv file and then use some local tools like excel to read that file.

Good. May I ask you to point the API function(s) you are talking about?

I believe you can either use firefox or chrome to see if your feed works for you.

<your domain string>/activity?os_authType=basic

It should prompt you for username and password.

Norman, the "someone's activity" is not "list of issues". I need list of issues, not actions. Thank you anyway.

No, It shows everyone's activity that your login permission allows. I see all of my co-workers as well as mine when I run the url.

Yes, of course. But you see, I need list of issues, not the activity from JIRA, Confluence, Bamboo, etc. :)

Cheers

The issue key is returned along with the action and user. You even have filters to get particular issues as well, There are various filters such as project updated date, user, transitions, etc. Yes, you might need to write some scipting code if all you want is a single row, but that code should be straight forward. Everything you asked for is being returned.

Oh, I am terribly sorry. I forgot to mentions that JIRA is OnDemand one.

Thank you anyway, Norman.

Did you look in the market place. There are a couple of activity stream reports that might work depending on your Jira version the permissions of the user needing to see this information.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you