is there way to use wild card characters in basic filter or jql?

[Ramesh Krishnan]

I would like to search in jql with keywords using wild card characters, is there any jql syntax?

[John Funk · Accepted solution]

Hi Ramesh,

The Project field is not a text field - the ~ only works with text fields. 

There is an open feature request with Atlassian for that if you would like to vote for and follow it. 

https://jira.atlassian.com/browse/JRACLOUD-43398

[Ramesh Krishnan]

Voted

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Ramesh Krishnan

I understand that you want to do a partial text search across your project names. To the best of my knowledge, that's not possible in native JQL/Jira - the project field doesn't support text searching.

The only workaround that I could think of is to use Jira Automation to copy the project name into a custom field (e.g. of type single-line text) and then use this custom field for searching, but it would complicate your setup quite a bit, and I wouldn't personally recommend it.

Alternatively, if you're open to solutions from the Atlassian Marketplace, you'll have more options available. I'll add more information below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

... and to expand on my previous point: If you're open to solutions from the Atlassian Marketplace, you're use case would be easy to solve using the app that my team and I are working on: 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. One filter option that is available for all fields is text filtering, which performs a partial match by default. 

This is how it looks in action:

For more advanced use cases, you can also use logical operators (AND, OR, NOT) or even regular expressions.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions let me know!

[Richard · Accepted solution]

You could use the jql "text ~ [insert string] AND text ~ [insert string]" for matches of the string you're looking for. 

[Richard]

Search syntax for text fields | Jira Software Data Center 10.5 | Atlassian Documentation

Here's a pretty good source of information for text searches

[Ramesh Krishnan]

Tried with below syntax in jql as per the link, getting below error

Project ~ "Issue*"

The operator '~' is not supported by the 'project' field.

[Ramesh Krishnan]

text ~ [insert string] - this query pull every column, i wanted to pull only specific column.