Referencia al titulo

Question

Hola,

Tengo dos filtros que se llaman:

"[MANU] INC Aplicaciones"

"[PEPE] INC Aplicaciones"

Y tengo otros dos filtros que hace referencia a los anteriores:

"[MANUEL]Incidencias abiertas" tiene la siguiente query:

filter = "[MANU] INC Aplicaciones" AND status not in (Closed, Acceptance)

"[PEPE] Incidencias abiertas" tiene la siguiente query:

filter = "[PEPE] INC Aplicaciones" AND status not in (Closed, Acceptance)

Me gustaría montar algo así:

"[MANUEL]Incidencias abiertas":

filter = concatenar substring (6 caracteres de la izquierda del titulo de esta query) + INC Aplicaciones" AND status not in (Closed, Acceptance)

El resultado sería:

filter = "[MANU] INC Aplicaciones" AND status not in (Closed, Acceptance)

Esto lo quiero hacer así para tener solo un filtro para ver las incidencias abiertas y no hacer un filtro por cada persona.

Muchas Gracias!!!

Jose

Hannes Obweger - JXL for Jira · Answer

... and just to add to the above: For more advanced use cases, there are a range of apps available in the Atlassian Marketplace that either extend JQL by additional functions, or offer alternative search and filter mechanisms.

For example, my team and I work on an app in which your use case would be easy to solve: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to filter issues via regular expressions.

With regular-expression-based filtering, you can apply pretty much any logic, including the one that you are after:

The regex that I'm using is

^$$\w\w\w\w$$ INC Aplicaciones$

There's a few things going on here, but TLDR, it matches all <any-4-character-word>] INC Aplicaciones values.

Once you've identified your issues, you can work on them directly in JXL (e.g., bulk edit them via copy/paste), or trigger various operations in Jira.

Hope this helps,

Best,

Hannes

Hannes Obweger - JXL for Jira · Answer

Hi @Jose Lago

welcome to the community!

If I understand correctly, you want to filter all issues with a summary of [<something>] INC Applications - is this correct? You may want to play around with JQL's wildcard system (*), e.g. with a query like this:

summary ~ "\"* INC Aplicaciones\""

(See here for more details on advanced JQL.)

How does this look for you?

Ste Wright · Answer

Hi @Jose Lago

Not quite sure what you mean here - can you clarify?

Are you trying to have two filters in the sub-filter? If yes, you can do this using "filter in ()", rather than "filter="

Ste

---

And in Spanish, according to Google Translate...

No estoy muy seguro de lo que quieres decir aquí - ¿puedes aclarar?

¿Estás intentando tener dos filtros en el subfiltro? En caso afirmativo, puede hacerlo utilizando "filtro en ()", en lugar de "filtro="