Forums

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

Setup JQL filter to check if a specific user had assisgned jira's for more then x days

Morosanu Dan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 18, 2018

I need to setup a jira JQL filter that shows me if a user had in a specific time frame jira's assigned to him for more then XX days.

 

Does anyone know how to do this? 

Thank you in advance

 

 

1 answer

0 votes
Tyler Brown
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 18, 2018

Hey Morosanu,

You should be able to use: "assignee changed to [username] after [timeframe]"

You can replace [timeframe] with one of the jira provided endof or startof functions or put in a custom date.

Hope this helps,

Tyler

Morosanu Dan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 19, 2018

Thanks for the hint.

I tried something like:

issuetype in (Bug, Improvement) AND assignee changed to dan.morosanu after startOfYear()

but is not quite what I need.

I want to find e.g. if in the last 6 months the user dan.morosanu has or had  any jira's assigned to him and the jira stayed like that for more then 30days. 

Suggest an answer

Log in or Sign up to answer