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; } } }

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

Vasyl Boroviak1

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?

Accepted answers

All comments

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.

Vasyl Boroviak1

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

Thank you anyway, Norman.

Bhushan Nagaraj2

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 Boroviak1

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.

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 Boroviak1

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.

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

Kane McConnell

Is this what you're looking for?

issue in issueHistory() ORDER BY updated DESC

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

Jesse Sanford_n7kx2n

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 wink

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

You can test it for free up to 6 months.

Ugubi Team

Gatsby Wang

Is there a cloud solution for this?

Thanks

Greg Carpenter

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

Adam Knight_1qeda1

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

Samira Negm

Which plugin?

Sebastien De Luca

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

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?

Daniel Turczanski - JQL Search Extensions

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

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-cloud

jql