nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Performance issues when using multiple filters

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)

Accepted answers

All comments

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.

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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server