Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

For saved filters in Jira, is the count pre-computed? Edited

Also, I would generally like to know if there are any optimisations done around saved filters

2 answers

@Ranjith Chaz

The filter is always updated in real time. Whether saved or not, just redo the search.

What do you mean by optimizations?

Sometimes simple querry like sorting issues by lets say priority, can malice domain.

The action of just filtering does not interfere with the items. You can do this in a second action, if you wish. But filters work like queries.

Thanks, @Roberto Miasack 

What do you mean by optimizations

Optimisations could be creating indexes based on the where clause of a saved filter. Looks like that is the case from @Nic Brough _Adaptavist_ 's comment

1 vote

Partly.  The data in the database is not built for reporting at all, but it is completely re-organised in the index.   The index is also not built for reporting, but it is built for searching and so the information like "number of results from a filter" is quickly available without having to run the filter against the database and count.

Exactly as Roberto says, the act of filtering has no effect on the data, it's completely read-only.

To "optimise" filters though, you just keep them as simple as possible.

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you