JQL query to search for all issues that have been evaluated after a specified time at the latest

Jasmin Bohlen

Hello together,

After each sprint we want to search for all issues that have been evaluated maximum 5 days after they were created.

I've  been thinking about two options:

1.

Label the issues when they have been evaluated and after that search for all issues where (Date the issues were labelled - Creation date) < 5days .

2.

Set an End-Evaluation Date Picker and after that search for all issues where (End-Evaluation-Date - Creation Date) < 5days.

 

Is one of the options possible, if yes- how can this be realized with JQL?

Thank you very much!

Antoine Berry

Hi @Jasmin Bohlen , welcome to the community !

Out of the box I do not think this is possible. However you could use an app such as ScriptRunner to auto populate the Evaluation date custom field. Two ways of doing that : 

• Have a postfunction/listener that sets automatically the value of the field
• Have a behaviour setting the date on the screen of the evaluation transition

Then you could use the dateCompare JQL to compare creation date and evaluation date.

Antoine