Confluence:When we are trying to insert a JIRA query using insert JIRA issue/filter and insert the output by selecting "Total issue count" under "Display options" the insertion is getting time out. Please find the error attached.

swetha meti

 error screenshot is attached.Server logs shows the error as com.atlassian.confluence.content.render.xhtml.XhtmlTimeoutException: Rendering this content exceeded the timeout of 5 seconds

 

The query we are using is below project = CE And priority = "1 - Blocker" AND issueFunction in dateCompare("", "created > resolved -1d")  AND resolutiondate > "2016/11/01" AND status changed to resolved by (user1)

 

Here the issue is with issueFunction bcz we tried with a query without issueFunction and that worked without any problem/timeout.

 

Since issueFunction is creating performance issue or getting timeout, can we have any other alternatives in our requirement? Basically our requirement is as below:

We would like to capture how many CE tickets are resolved within a defined resolution time per resource (Per our SLA)

For example: We would like to capture how many blockers CE tickets are resolved by X resource within 24 hours in last 30 days. Here 24 hours are TTR(SLA) for blocker ticket.

 

Could anyone advice on this.

 

Screen Shot 2016-12-30 at 3.43.43 PM.png

Screen Shot 2016-12-30 at 3.43.25 PM.png

image2017-1-4 12:6:28.png

image2017-1-3 13:44:27.png

image2017-1-6 10:9:0.png

image2017-1-6 10:6:43.png

image2017-1-3 13:48:27.png

image2017-1-4 12:26:11.png

Screen Shot 2016-12-30 at 3.43.43 PM.png

Screen Shot 2016-12-30 at 3.43.25 PM.png

image2017-1-3 15:29:1.png

image2017-1-4 12:22:16.png

image2017-1-4 12:21:47.png

image2017-1-3 13:49:29.png

image2017-1-4 12:5:12.png

image2017-1-3 13:43:7.png

Sam Hall_h1otcf

Hi Swetha,

Am I right in thinking that "dateCompare" is a function provided by ScriptRunner for JIRA?

If so, I have a suggestion based on information here where it mentions about performance: https://scriptrunner.adaptavist.com/4.3.0/jira/jql-functions.html#_performance_2

Try re-structuring your query so that you filter out issues using the sub-query inside dateCompare.

For example, something like:

<span>issueFunction in dateCompare("project = CE AND status changed to resolved by user1", "created > resolved -1d") AND priority = "1 - Blocker" AND resolutiondate > "2016/11/01"</span>

Hope this helps.

I've also tagged your question with some more labels which will highlight it to other community members who may be able to help.

Sam