Issue with subtasks display on Kanban board being delayed.

[Stu]

Hi, I have Kanban boards within a project that displays issues as swimlanes, and then the main tasks assigned to people to do work, are subtasks subordinate to the issues.

I have the following example script I created with Scriptrunner for my Kanban board.

project = "ICS - Engagement and Projects" AND (issuetype = Initiative OR issueFunction in subtasksOf("issuetype = initiative")) ORDER BY Rank

The issue is that when users create new subtasks, there is a 1m delay before the subtasks display on the board.  I understand that Scriptrunner is doing some backend processing or syncing, then modifying the actual script that jira uses.  Within the settings of scriptrunner i can get this processing frequency down to a 1min.   However this is causing major confusion with my users, and people basically don't like the way it operates.  So much so that I"m considering redesigning the whole way my Jira and boards work, which I don't want to do as it would be a big job.

Hoping their is some other way i can fix this?  Let me know. I'm open to using other add ons, but i don't think there are any.  Thanks in advance.

[Javi]

Hi Stu,

In regards to alternative methods with native Jira JQL, I was unable to find any.

You can try limiting your JQL to a smaller subset of issues in case your current query is pulling tons of issues and this can help improve performance. (See: ScriptRunner Performance)

So for example, you can specify issues within a project and created after a certain date/using a unique label/etc

Additionally, if it is indeed the issueFunction clause causing slowness, which you can also determine by checking the atlassian-jira-slow-queries.log, I recommend contacting Adaptavist support. As the function is not something we can change, Adaptavist may have some recommendations we are unaware of that can help with this issue

Regards,

Javier A.