How to find all projects worked on by a specific user?

[marshallmm]

So we currently have a digital contractor and we are trying to generate a report of what projects they have worked on throughout their time with us. We have a custom Digital input for that, so I was able to recover some issues. Would there be any way to pull up a full report on what things they have worked on, that doesn't relate with the assignee fields? (seems like a stretch, but I wanted to message here to make sure)

[Bastian Stehmann · Accepted solution]

Hi @marshallmm ,

How do you define that the contractor has worked on a project if it is not the assignee?

I think it depends on that if there is way or not.

[marshallmm]

Originally we had our Digital manager as the assignee, but once they got settled, they tracked time in issues as well as commented. I know that there are logs for time and labels for commenters, so would that be searchable?

[Bastian Stehmann]

I think you'll need an app like scriptrunner. This brings an JQL function at least for the comments and worklogs.

I don't think there us a way out of the box.

[Sunny Ape]

You'd have to do multiple searches against multiple parameters to find where the user had 'touched' different parts of different objects in a Project. That's a big ask. You might be best to just start with finding when they changed an Issue, irrespective of the Project it was in.

Given that everything a user does to an Issue is recorded in the logs, you'd get the log files for a batch of issues, then filter the results to find if the user's name was in each log, then re-filter to see what they did in that log entry, but it's still going to be fairly big dataset to wade through.