Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Sara Dufour April 15, 2019

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!

2 answers

1 vote
David Hibler April 16, 2019

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

0 votes
John Funk
Community Champion
April 15, 2019

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!

Activity Stream.PNG

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events