JIRA Advanced query | Filter by user + time-frame (hours and/or day)

Question

Hi,

I'm a complete beginner on Jira and I'd like to have analytics (or at least a search result) on a user's activity.

I was thinking of a query to see what "Bob" did on Jira after 7 pm and on weekends over the last X months. The goal is to point out, evaluate and address (potential) unusual workload.
Is it possible? If so, is there a tutorial somewhere?

Many thanks!

David Hibler · Answer

Sara, you could also create a custom JQL filter and save it under Issues and Filters.  I have one for my stand up meetings, but I tweaked it to more closely match your requirements.  This will show everything the user updated for the past 30 days that isn't a story.

assignee = john.doe AND updatedDate >= -30d AND Status != Stories ORDER BY Project, Status ASC

John Funk · Answer

Hi Sara - Welcome to the Community!

Maybe try adding an Activity Stream gadget to a Dashboard. See the screenshot below. It would give you only selected times, but hopefully you can quickly scan it to see the time or even do a CTRL F to look for times maybe.

Hope this helps a little!