Also, I would generally like to know if there are any optimisations done around saved filters
@Ranjith Chaz
The filter is always updated in real time. Whether saved or not, just redo the search.
What do you mean by optimizations?
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.
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
It looks like you're new here. Sign in or register to get started.
