filter - using a wildcard searching project

[Melissa Brady]

In the filters I want to search for all projects beginning with GIS

Examples:

GIS - Storymap

GIS - Parks Landuse

I am using 

resolved > -14d AND issuetype = Milestone AND status in (DONE, Done) and project = "GIS*" ORDER BY created DESC

and its not working.   what am I doing wrong.

[Petter Gonçalves · Accepted solution]

Hello Melissa,

Indeed, it's not possible using only JIRA JQL to search for projects containing a specific string, but only using a third-party app like Script runner as mentioned by @Alexander Bondarev.

That being said, we have a feature request to get it implemented here:

- Allow wildcard or '~' symbol to search for project/category name in JQL

Feel free to vote and watch the suggestion to increase its priority and also receive notifications about any updates.

[Alexander Bondarev]

is it clear that you want search by 'project'?

it seems to me, that you should change it for 'summary'.

also you should change '=' to '~',try this jql :

resolved > -14d AND issuetype = Milestone AND status in (DONE, Done) and summary ~ "GIS*" ORDER BY created DESC

[Melissa Brady]

When I change it to ~ it says 

Error in the JQL Query: The character '*' is a reserved JQL character. You must enclose it in a string or use the escape '\u002a' instead. (line 1, character 89)

And yes it’s the project field not summary. 

[Alexander Bondarev]

@Melissa Brady , do you haveScriptRunner for Jira? 

Look through Script JQL Functions - Regular Expressions - projectMatch(reg exp).

Check it please:

resolved > -14d AND issuetype = Milestone AND status in (DONE, Done) and project in projectMatch("^GIS*") ORDER BY created DESC

[Lexi]

@Petter Gonçalves - we see the same error when we try to wildcard search on the summary field. Do we need script runner for that as well, or is it just the project field that this shouldn't work for? 

We want to find summaries containing arch*

[Melissa Brady]

I get The value 'GIS*' does not exist for the field 'project'.