Performance issues when using multiple filters

[neelam annad]

Performance issues when using multiple filters in Jira3 or in confluence Jira macro -

if I run the below query it works fine-

project = xxxxxxx and issuetype in (story, task, spike) and status not in (open, closed)

bur if I convert it into multiple filters from reusability perspective I get  performance issues -

project = xxxxxxx and filter = “Open status missing summary”

”Open status missing summary” filter - issuetype in (story, task, spike) and status not in (open, closed)

[Nic Brough -Adaptavist-]

It's because the "filter =" function runs the query many times, stores the results and then has to re-read them again when it matches the other clauses.

[neelam annad]

What is the better way to create reusable filters? I have many projects that needs to run the filter I created - “Open status missing summary”.

i don’t want to create multiple filters for different projects.

[Nic Brough -Adaptavist-]

There is no "better" way - you're choosing convenience at the cost of inefficiency

[neelam annad]

Intent is for all the 100  teams in the company  to use the same 50 data quality queries what they need to do for their dashboard is to add only the project name like I showed above..

so I will be giving the filters to them. This way only 50 queries to be created, otherwise 100*50 queries...

Rally used to allow that. That’s why asked the question, by creating filters but performance is very slow 

[Nic Brough -Adaptavist-]

Why are you dictating reporting to teams that are supposed to be self-organising?

[neelam annad]

This is towards standard queries related to issues data quality exceptions that every team need to run and fix those exceptions. So scrum master can create those dashboards etc.