Search for issues between two date filters in JIRA 7.2

[Ezekiel Udoh]

I am trying to search for all the issues resolved a few days after they were created. Something like:

project = 'ABC' AND resolutionDate > (createdDate - "10d")

Any idea how to achieve this? I will appreciate some help with this.

[Alexey Matveev · Accepted solution]

Hello,

You could use the Power Scripts add-on:

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation

Your JQL query would look like this:

key in silJQLExpression("resolutionDate > created + \"10d\"", "project = ABC")

[Ezekiel Udoh]

Hello Alexey, thanks for the suggestion. I installed the add-on and did a re-index. Seems JIRA cannot still recognize the sil function. The error I am getting is 

"Unable to find JQL function 'silJQLExpression(resolutionDate > created + "10d")'."

[Alexey Matveev]

Go to add-ons -> Manage add-ons. Find Power Scripts and enable all modules:

[Ezekiel Udoh]

Hello Alexey, it worked! I can see results now. Really appreciate the help.

[Alexey Matveev]

You are most welcome!

[Ezekiel Udoh]

Hello again Alexey,

I am trying to modify this query to search across a number of projects. It is not returning any results, however.

key in silJQLExpression("resolutionDate > created + \"10d\"", "project in (ABC, DEF, GHI, KLM)")

Any idea what it is I am missing?

[Alexey Matveev]

It is strangle. Are you sure such issues exist in these projects?

[Ezekiel Udoh]

They do! But I will look for another way to identify them. Let me search around the existing community issues.

[Sreenivasaraju P]

@Ezekiel Udoh,

Out of the box, it is not supported. 

Please check third party plugins

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html 

https://community.atlassian.com/t5/Jira-questions/I-cannot-run-issueFunction-in-JQL/qaq-p/3899

[Sreenivasaraju P]

Hi @Ezekiel Udoh,

Out of the box, it is not supported. Please check with any custom plugin like script runner.

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html

https://community.atlassian.com/t5/Jira-questions/I-cannot-run-issueFunction-in-JQL/qaq-p/3899