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 · Accepted solution]

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

[Tomas Gustavsson]

Hi,

i think you should be able to do something like this.

first you need to create a date field e.g End-Evaluation.
then create a JQL filter somewhat like this,
project = "your project" and createdDate <= "2019-07-01" and "End-Evaluation" <= endOfMonth()

or you can use any of the other functions available below. 

you can find more information about advanced searching here
https://confluence.atlassian.com/jirasoftwareserver073/advanced-searching-fields-reference-861256237.html