is there a way to cascade /inherit filters?

[Marcelo_Aguisky]

In our organization we have many filters that share many of the same conditions in the SQL expression and every time we modify one, we have to modify all the others.

for example, there is a filter A that gives all the tickets that relate to all our customers

then there are two filters B and C that also give all the tickets that relate to all our customers but filter even more, for team B and team C.

So every time we add a customer we have to update filters A, B, and C with the new customer in the query.

Ideally, in a filter, I'd like to invoke another filter and process it's results.

Is this possible?

For example something like:

Filter A would look like:

customer = "cust1" or customer = "cust2" OR customer = "cust3"

Filter B would look like :

(filter: "filter A") AND team="B"

And

Filter C would look like :

(filter: "filter A") AND team="C"

[Marianne Miller · Accepted solution]

You're definitely on the right track! You can include a pre-defined filter into another filter.

For starters, I might make a suggestion to your Filter A

Customer in ('Cust1', 'Cust2', 'Cust3')

It will look like this:

filter = 'filter A' AND team = B

Filter = 'filter A' AND team = C

You can add other conditions as needed, but I think this will give you what you're looking for to get started.

Let us know how this works out for you!

Marianne Miller

[Marcelo_Aguisky]

Thanks!

It works perfect, although you need to be aware that it does not carry over the ORDERBY clause, so you have to add your own