I need to create a filter which includes task of the projects that contains "BFPMO" in their keys

[Elena Bertucco]

I need to create a filter which includes only the tasks that are in projects that contains "BFPMO" in their keys or "BF - PMO" in their name. I want to do it using JQL because i want it to update automatically every time i create a new project and not add manually the project to the filter

[John Funk]

HI Elena,

You would need to start your query with something like: 

Project in (BFPMO, BF-PMO, BFPMO2)  etc. by selecting the applicable projects. 

Or if you put in a category for the projects in the project details then you could query based on that category. But you can't do context searing on the project. 

[Lisa Forstberg]

Hi @Elena Bertucco ,

Do you mean that you have multiple projects that have BFPMO in their keys?

The JQL operators for Project does not allow you to search for "parts of project name" (yet) I am afraid. The JQL operators for key does have a > option but I wonder if that is a suitable option to explore.

Another way of solving it is to ensure the PMO-projects are connected to a project category.  In JQL you can query for a category to get a match on multiple projects. As long as newly created PMO projects also are added to the category the filter will be dynamic enough for you.

best regards

Lisa

[Elena Bertucco]

Hi @Lisa Forstberg ,

exactly that's my situation. Thank u for your help but I use the categoriesto make another Project subdivision so in this case their not usable. I need another way or I have to do it manually

[Lisa Forstberg]

All the workarounds I can think of (automations, assets, addons...) probably creates more maintenance work than accepting the fact that you need to manually change the JQL to add each newly created project.

Maybe an idea to post a product enhancement to Atlassian on this topic!

sorry for the dead end :-) 

take care 

Lisa