Advanced search "Filter" fieldtype

[Olivier Vandevoorde]

Are there best practices in usage of the advanced search Filter fieldtype? We want to create filters which all depend on 1 other saved filter.

For instance :

filter 'MyProjects' : "project in ("projectA", "projectB", ....,"projectX")

filter OpenIncidentsIssues : "status = Open AND issuetype = Incident AND filter = MyProjects

In that way if a new project is added, we only have to change 1 filter.

And what is the impact on performance?

[Ramiro Pointis]

Hi Olivier iy you want a little more info of that you can see here:

http://stackoverflow.com/questions/12257496/jql-filter-other-query

Now, the impact on your performance it's the same I think. The problem will be the maintenance, if you have:

filter 'MyProjects' : "project in ("projectA", "projectB", ....,"projectX")

And you name this filter MyProjects2 and then you want to add more:

filter 'MyProjects2' : "project in ("projectA", "projectB", ....,"projectX")

You will have junk filters all over, and will be difficult to know what filters are for use and what for dump. And knowing what you have on MyProjects will mean you have to go inside MyProjects2 and then going inside MyProjects. Imagine if you have like 10 filters chained like that.

I think it's better to change filters whenever you need to add projects.

[Ramiro Pointis]

Just in case, there's a plugin for advance filters, here you have the list of tricks for JQL:

http://www.j-tricks.com/jql-tricks-plugin.html

Problem is that it's not free.