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

[Vasyl Boroviak]

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?

[Kane McConnell]

Is this what you're looking for?

issue in issueHistory() ORDER BY updated DESC

[Adam Knight]

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...

[jaromor]

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()

[Bhushan Nagaraj]

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

[Vasyl Boroviak]

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.

[Jesse Sanford]

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

[Ugubi.io]

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

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

You can test it for free up to 6 months.

Ugubi Team

[BigBrother]

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

[vpgleghorn]

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')

[jennifer smith]

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.

[Miguel Costa]

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

[Michael Frederick]

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

[Vahur Meus]

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!

[Jovana Markovic]

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

[AJ DaNelz]

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

Participants = currentUser() ORDER BY updatedDate DESC

[Samira Negm]

Which plugin?

[Daniel Turczanski - JQL Search Extensions]

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

[Servicedesk]

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

[Greg Carpenter]

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

[Gatsby Wang]

Is there a cloud solution for this? 

Thanks

[Ugubi.io]

Hi,

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

Best regards,
Ugubi Team

[Norman Abramovitz]

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.

[Vasyl Boroviak]

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

[Norman Abramovitz]

Here is the url

https://developer.atlassian.com/display/DOCS/Consuming+an+Activity+Streams+Feed

[Norman Abramovitz]

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.

[Vasyl Boroviak]

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

[Norman Abramovitz]

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.

[Vasyl Boroviak]

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

Cheers

[Norman Abramovitz]

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.

[Vasyl Boroviak]

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

Thank you anyway, Norman.

[Norman Abramovitz]

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.