Boards Failing to Load With Complex Cross team filter

[Nadia Khan]

We have complex filters that were running behind boards that pull tickets that other cross teams are working on are not loading.  Filters are using Script runner enhances search functions so we can pull on Custom field like primary team associated with Epics/Parents owned by a particular team or not. This is important for our Kanban teams and Service management teams and Scrum teams that need visibility into their feature related cross team work.  Here is an examples of the filter

Project = INDC AND (resolution is EMPTY OR resolutiondate >= startOfMonth(-2)) OR "Primary Team" = "ITS Network Database & Cloud Team" AND (resolution is EMPTY OR resolutiondate >= startOfMonth(-2)) AND project != Intake OR key in epicsOf("Project = INDC AND 'Primary Team' != 'ITS Network Database & Cloud Team'") AND (resolution is EMPTY OR resolutiondate >= startOfMonth(-2)) ORDER BY Rank

Project in (ISS, ISO) AND (resolution is EMPTY OR resolutiondate >= startOfMonth(-2)) OR "Primary Team" in ("Salesforce Strategy & Implementation​", "ISO Team") AND (resolution is EMPTY OR resolutiondate >= startOfMonth(-2)) AND project != Intake OR issueFunction in epicsOf("project in (ISS, ISO)") AND (resolution is EMPTY OR resolutiondate >= startOfMonth(-2)) ORDER BY Rank

This board loading failure started happening this week and these filters were working fine before. Working with Adaptavist support but thought to tap into smart brains here in community that might have insight and suggest optimization of the filter or other guidance taking into consideration apps moving to Atlassian Forge. Thanks

[Trudy Claspill]

Hello @Nadia Khan 

Do you get an actual message about the board failing to load? How long does it take for that message to appear?

Do the filters work when you run them through Enhanced Search? How long do they take to return data?

When you created the board did you reference the saved Enhanced Search filter as the board source? 

Have the number of issues in the projects referenced in the epicsOf() functions changed significantly recently?

[Nadia Khan]

@Trudy Claspill 

Hi Trudy,

Thanks for taking the time to respond. I don't get any messages when I access the boards , I see a blank board trying to load the tickets forever- screenshot below.

Error that I see is when I try to access the board settings while the board is still loading- see screenshot.

When we create these complex filters we create them in Scriptrunner enhanced search and then reference the existing filter on the boards.

Yes, Filters are yielding results when I run them through Enhanced Search, and results come up very quickly within a few seconds.

As we are looking back only 2 months, number of tickets have not increased recently.  We are having this problem with all the teams not just one specific extra busy team.

Someone suggested changing ownership of the filter to an active user and I did that without any success. Most of them have been created by employee that has retired, but all was well last week and not this week so still tested it by changing ownership.

I hope that helps