How can I search for text in non text field?

[James Park]

I would like to search for a project that starts with "S-".

However, the "project" field is not a text field.

Can I use JQL with wild character search like project = "S-*" ?

How can I search for all projects containing a specific string of letters?

Thanks.

[Payne · Accepted solution]

If you happen to have the ScriptRunner app installed, it has a handy projectMatch function that can be used for this purpose.

e.g. project in projectMatch("^PRJ.*")

[mauricio.groth · Accepted solution]

Hi @James Park 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all your issues that are in a project that starts with S-

issue in wildcardMatch("project", "S-*")

Check out the documentation for more examples.
I hope this helps!
Maurício

[Dave Theodore [Coyote Creek Consulting]]

You can't do a wildcard as you are suggesting.  You could use the "IN" Operator to indicate multiple Projects should be queried, though. ie:

project in ("project a","project b") ...

[James Park]

Good suggestion but that is not what I was looking for.

Can I do search like

project in ("proj*)

?

[Dave Theodore [Coyote Creek Consulting]]

You cannot use a wildcard in that manner. You would need to use the syntax I provided above in order to select multiple Projects.