JQL for issues commented by assignee within 7 days after been assigned

[Pengshan Dai]

Dear Community,

I'm trying to filter the issues got responded <7 days by assignees after they are been assigned. Comments or change status consider as response to the issue.

Within an issue workflow, there might be two assignees in total.

I have installed ScriptRunner, but can not figure out what JQL to complete this function. 

Thanks!

[Cristian0791]

Hi Pengshan,

You can try the groovy script:

issueFunction in issueFieldMatch("", "assignee", ".*") AND issueFunction in dateCompare("", "issue.history[commented, status changed] <= assignee[date] + 7d") 

[Pengshan Dai]

Hi Cristian, thank you for your help.

I tried it in ScriptRunner Enhanced Search:

issueFunction in issueFieldMatch("project = AMSELC", "assignee", ".*") + issueFunction in dateCompare("project =AMSELC", "issue.history[commented, statuschanged] <= assignee[date] + 7d")

But got error:

Found '.history[commented,statuschanged]' instead of .clearTime()

Did I do anything wrong?

[Pengshan Dai]

How to specify the person who commended shall= assignee?

[Cristian0791]

Can you please try: 

(issueFunction in issueFieldMatch("project = AMSELC", "assignee", ".*")
AND (issueFunction in commented("after -7d") OR status CHANGED AFTER -7d))

This approach gets you closer to filtering issues where assignees responded (via comment or status change) within the timeframe you want.

[Cristian0791]

issueFunction in commented("by assignee after -7d")

This query will return issues where the assignee made a comment within the last 7 days.

[Pengshan Dai]

Hi Cristian, thanks a lot for your reply. Unfortunately I got return,

Function 'commented' does not exist

I am using ScriptRunner Enhanced Search, do I need to download any extra app?

Best,

[Cristian0791]

Since you're using ScriptRunner Enhanced Search, you don't need to download any extra app. The commented function should work as part of the functionality provided by ScriptRunner.

Check Commented Function: Verify that the commented function is correctly enabled in your instance by going to Administration > Add-ons > ScriptRunner > Built-in Scripts and ensuring the function is available.

[Pengshan Dai]

I will check this with our administrator for JIRA. Thank you for your hint!

[Ryan J Stagg]

@Cristian0791 is it possible you're using Jira Data Center here?  Even the docs for ScriptRunner Cloud say Commented is not supported:

[Pengshan Dai]

How can we add Commented Function? 

[Cristian0791]

Oh, got it! You're right, I’m using Data Center. Sorry for the mix-up!